Click on Tools in the menu and click on Options. In the Options dialog box
click on the View tab and locate the Check Box that says Zero Values. The
check box is located in the Windows Options panel of the View page. Click
this off to have zero values suppressed.
--
Kevin Backmann


"junkmandan" wrote:


How can I insert a formula, say the sum of a column, without the cell
showing a zero sum, until the formula has been applied. My form looks
messy with all the zero values without any other information in the
form.

Thanks


--
junkmandan
------------------------------------------------------------------------
junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866
View this thread: http://www.excelforum.com/showthread...hreadid=505450