Display of a negative percentage in Excel with Brackets (22%)?

[Jill]

Is there a way to display negative percentages using brackets?
IE -4% or (4%).

Thank you,

 

[Rick Rothstein]

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.

 

[JoeU2004]

Is there a way to display negative percentages using brackets?
IE -4% or (4%).

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%);_("-"??_)