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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Brackets on negative percents. 3
IIS logs, repeated hits to a car picture? [interesting story!] 7
percentage in brackets 2
DLookup in query; percentage format 1
[Update] HTTrack Version 3.40-2 (04/09/2006) 2
Custom cell format for percentage 3
Calculating percentage of non-numeric values. 4
How do I show negative percentage in a fomula? 1

Top