Special format for negative figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get parenthesis i.e. () for negative %
Ex: (-5%)
as we get for numbers

Though managed to get it red coloured thru Conditional Formating

Pls Help
 
Highlight the cells you want to format this way
Right click on the cells and select > Format Cells
On the number Tab, choose Custom
In the "Type" box enter:

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

Special format for negative figures 2
Red cell for negative numbers in Excel 1
Question about conditional formatting of zeros in Excel 0
Negative Numbers 10
formatting negative numbers 1
negative currency abbreviated format 1
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Conditional Formatting using Traffic Lights 6

Back
Top