"Kevin B" wrote in message
...
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.

That might drive him nuts 2 years from now when he *wants* zeros to show on
a certain sheet, and doesn't remember having adjusted that option. :-)