View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CIW CIW is offline
external usenet poster
 
Posts: 4
Default 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)