View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pford pford is offline
external usenet poster
 
Posts: 1
Default Formatting a Spreadsheet

I know there is probably a simple answer to this, but I have a spreadsheet
that someone else created. In that sheet there are various formulas and 1
column is based on the difference of 2 other columns. The question is about
the column that has the total, if the total is $0 is does not show up, but if
I hightlight several of the cells you can see there are zeros, almost like
the font color is white. There are several cells that I had to change the
formula and now the $0 always show up. How do I make them invisible like the
other cells.

Any help is greatly appreciated