hi,
formating will not do that. all formating does is change the way data looks
on the sheet. It does not change the data nor can it make decisions based on
conditions.
try a formula like this.....

=IF(SUM(D1:D3)=0,"",SUM(D1:D3))

regards
FSt1

"Louise" wrote:

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