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

Or turn off Zero displays under Excel Options.


--
Regards
Dave Hawley
www.ozgrid.com
"DeeDeeCee" wrote in message
...

I have a column whose cells are formatted to take one number from Cell A,
another from Cell B, then add them add divide by two (i.e., average them).
The problem is that many of the rows don't have anything in Cell A and B,
and
the result shows as "00.00". This gets in the way of seeing the rows where
there is data available, and therefore useful information. Any suggestions
on
how to set up my formula so that it just doesn't show if the "result" is
0?

Thanks.

ddc