Tools | Options then the [View] tab - clear the checkbox next to "Zero
Values". Smile.

Hope this helps some.

"Deb" wrote:

Is it possible to to change the default in excel so 0 values do not display
unless desired. As it is now EVERYZTIME I have to go into Windows/excel
options and unclick the display zero values...'

--
dbutcher