T Tophan Registered User. Local time Today, 13:22 Joined Mar 27, 2011 Messages 389 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, 18:22 Joined Feb 19, 2013 Messages 17,760 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, 13:22 Joined Mar 27, 2011 Messages 389 Jul 7, 2014 #3 Thank you very much. Worked perfectly.
