Hi

=IF(YourFormula=0,"",YourFormula)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Louise" wrote in message
...
Hi all

I have formulas on my worksheet and several of the 'answers' are zero,
which
is correct, however, I want to format the whole worksheet so rather than
displaying '0', it simply leaves the cell blank.

How would I do this?

Thanks.
Louise