View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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,