On Dec 17, 12:47*am, Rich wrote:
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,

=IF(Formula=0,"",Formula)