Hi SEF,

As long as you want to hide all zero values on a sheet you can use in
excel 2003
From the Tools menu select Options
On tab View uncheck Zero Values

If you only would like to hide the zeros from the formula results you
can use conditional format for the result cells.
How this works depends on the excel version you arre using.
Look at the online help.

An other option is to use the number format for those cell with
something like:
#.##0_);[Red](#.##0);[White]0;[Blue]@

HTH,

Wouter