Tools Options, on the View tab under Window otpions uncheck the "Zero
values" box.
"thesuperhero" wrote:
This may be so simple however I cant figure it out. I do not want to
see zeros, I only want the cells that have a value of greater that zero
to show on my totals page. Sheet 1 is my total page sheet 2 -13 are the
monthly numbers.
How do I hide the value of zero on my total page?
Scott
--
thesuperhero
------------------------------------------------------------------------
thesuperhero's Profile: http://www.excelforum.com/member.php...o&userid=29828
View this thread: http://www.excelforum.com/showthread...hreadid=495323