percentage in brackets
 

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)

percentage in brackets
 

Format Custom as
0%;(0%)
or of course
0.00%;(0.00%)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CIW" wrote in message
...
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)

percentage in brackets
 

FormatCellsNumber tabselect 'Number' and select the format from the list
'Negative Numbers'

If this post helps click Yes
---------------
Jacob Skaria


"CIW" wrote:

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)