percentage in brackets

  • Thread starter Thread starter CIW
  • Start date Start date
C

CIW

I have input a formula that calculated the percentage increase (decrease)
from a figure in a particular year. If I format the cell as percentage, the
negative (decrease) percentage has a minus sign. I would like the percentage
to show up in brackets. Is there any way to input the formula yet still have
the decrease show up in brackets? (I'm using Excel 2002)
 
FormatCells>Number tab>select 'Number' and select the format from the list
'Negative Numbers'

If this post helps click Yes
 

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

percentages 2
difference in numbers displayed as a +/- percentage 3
Percentage Increase 13
DIFFERENCES IN PERCENTAGES 1
Median If Function 3
How do I show what the percentage is of one figure to another? 7
Formula for Annualized percentage 7
Vertical Growth Percentage? 3

Back
Top