Custom Format the cells as: General;-General;
http://www.ozgrid.com/Excel/CustomFormats.htm

Or, Under Excel Options hide zero values.



--
Regards
Dave Hawley
www.ozgrid.com
"DeeDeeCee" wrote in message
...
I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the
rows, there is no "input" data, and so the calculation simply indicates
the
answer is zero. This gives me a column with lots of zero's in the cells.
I'd
prefer there simply to be a blank cell, whenever the result of the formula
is
zero. Is there a way to achieve that?

Thanks much.

ddc