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

Thank you,

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.

--
Rick (MVP - Excel)


"Jill" <Jill @discussions.microsoft.com wrote in message
...
Is there a way to display negative percentages using brackets?
IE -4% or (4%).

Thank you,

"Jill" <Jill @discussions.microsoft.com wrote:
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%);_("-"??_)