How do you format a percentage in brackets (3.40%) vs. -3.40%

  • Thread starter Thread starter Jim
  • Start date Start date
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%)
 
Back
Top