View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Formula returning a blank cell if answer is zero

In Excel 2003, I have a worksheet that has formulae in a column. If the
result is zero, it displays a zero. I copied the column to another worksheet
and on that worksheet, if the result is zero, the cell is blank. Where is
the switch to have it show zero or show blank? I'm quite sure it exists...I
just don't know where.

Thanks,