Hiding zeros on my worksheet

[thesuperhero]

This may be so simple however I cant figure it out. I do not want t
see zeros, I only want the cells that have a value of greater that zer
to show on my totals page. Sheet 1 is my total page sheet 2 -13 are th
monthly numbers.

How do I hide the value of zero on my total page?

Scot

 

[Guest]

Tools > Options, on the View tab under Window otpions uncheck the "Zero
values" box.

 

[thesuperhero]

Thanks, worked perfectly. I knew it had to be simple