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

S

Sean Timmons

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%)
 
Top