Thread: How do you format a percentage in brackets (3.40%) vs. -3.40%
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default How do you format a percentage in brackets (3.40%) vs. -3.40%
Go to Format Cells, go to custom:

0.00%;(0.00%)

and, if you want negative to show in red:

0.00%;[Red](0.00%)


"Jim" wrote:

How do you format a percentage in brackets (3.40%) vs. -3.40%
Reply With QuoteReply With Quote