Display of a negative percentage in Excel with Brackets (22%)?

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

Is there a way to display negative percentages using brackets?
IE -4% or (4%).

Thank you,
 
Use this in a Custom Format...

0.00%;(0.00%)

Use as many zeroes as you want decimal places in your answer. You can also
use # signs in place of the zeroes, but the decimal point will be displayed
for whole numbers.
 
Jill said:
Is there a way to display negative percentages using brackets?
IE -4% or (4%).
Click to expand...

If that is all you want, use the following custom format:

0.00%;(0.00%)

If you would like negative to be red and you would like zero to appear as a
dash, similar to Accounting format, use the following custom format:

0.00%;[Red](0.00%);_("-"??_)
 
You must log in or register to reply here.

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

percentage in brackets 2
Excel Excel 2010-how to display negative % with brackets 0
Access Negative Percentages in Report in Access 2007 0
Brackets on negative percents. 3
Red cell for negative numbers in Excel 1
Displaying negatives with (brackets) 3
Custom cell format for percentage 3
Negative percentage in data verification dropdown list? 2

Back
Top