View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emil emil is offline
external usenet poster
 
Posts: 49
Default How to Show "+" for positive and "-" for negative

I have a cell which fluctuates based on its formula between positives and
negatives. (I use Excel 2007 if that matters).

When the value is negative it always shows the "-". How can I make this
also show the "+" if the value is positive?

Thanks in Advance,
Emil