T Tophan Registered User. Local time Today, 12:37 Joined Mar 27, 2011 Messages 374 Jul 7, 2014 #1 Good Morning, Is there a way to show negative numbers in brackets without selecting the Currency format? I want to show (75,000.00) and not -75,000.00 Thanks in advance for your help.
Good Morning, Is there a way to show negative numbers in brackets without selecting the Currency format? I want to show (75,000.00) and not -75,000.00 Thanks in advance for your help.
C CJ_London Super Moderator Staff member Local time Today, 17:37 Joined Feb 19, 2013 Messages 17,392 Jul 7, 2014 #2 use the format property for the control #,##0;[Red](#,##0) will produce 1,100 (1,200) 0;[Red]-0 will produce 1100 -1200
use the format property for the control #,##0;[Red](#,##0) will produce 1,100 (1,200) 0;[Red]-0 will produce 1100 -1200
T Tophan Registered User. Local time Today, 12:37 Joined Mar 27, 2011 Messages 374 Jul 7, 2014 #3 Thank you very much. Worked perfectly.
