J Jill Aug 24, 2009 #1 Is there a way to display negative percentages using brackets? IE -4% or (4%). Thank you,
R Rick Rothstein Aug 25, 2009 #2 Use this in a Custom Format... 0.00%;(0.00%) Use as many zeroes as you want decimal places in your answer. You can also use # signs in place of the zeroes, but the decimal point will be displayed for whole numbers.
Use this in a Custom Format... 0.00%;(0.00%) Use as many zeroes as you want decimal places in your answer. You can also use # signs in place of the zeroes, but the decimal point will be displayed for whole numbers.
J JoeU2004 Aug 25, 2009 #3 Jill said: Is there a way to display negative percentages using brackets? IE -4% or (4%). Click to expand... If that is all you want, use the following custom format: 0.00%;(0.00%) If you would like negative to be red and you would like zero to appear as a dash, similar to Accounting format, use the following custom format: 0.00%;[Red](0.00%);_("-"??_)
Jill said: Is there a way to display negative percentages using brackets? IE -4% or (4%). Click to expand... If that is all you want, use the following custom format: 0.00%;(0.00%) If you would like negative to be red and you would like zero to appear as a dash, similar to Accounting format, use the following custom format: 0.00%;[Red](0.00%);_("-"??_)
