Blank result cell instead of zero

  • Thread starter Thread starter Rich D
  • Start date Start date
R

Rich D

In Excel 2003, I have identical formulae in defferent worksheets. In one
worksheet if there is no result, it shows a zero. In the other worksheet,
the cell is blank. I think there is a switch someplace to show zero or blank
but I don't know where it is. How can I make that choice? I don't
understand how the two different worksheets got set different. 1 was a copy
of the other...does that have something to do with it?

Thanks,
 
Back
Top