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
news:081F1E28-9451-4B07-852F-(E-Mail Removed)...
> 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%);_("-"??_)