Display of a negative percentage in Excel with Brackets (22%)?
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,
|