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

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

I misread your question initially and told you to do exactly what you're
doing now.

You have a couple of options for toggling the viewing of zero values without
going through Tools | Options.

Easiest way is to probably record 2 macros; 1 recording while using Tools |
Options to hide zero values and a second one to display them. Assign
shortcuts to them and use those shortcuts to toggle zero value display when
you want to.

Another, more complex, way would be to designate a cell to hold a "flag"
value (0 or 1) and use that as part of an IF(AND()) formula to hide/display
zero values.

Let's say you choose cell A1 as the 'flag' cell: when it has a 0 in it, you
do not want to see zero values, when it has something other than 0 in it, it
means you do want to see them.

Now, down in another cell you have a formula like =D5+D6 which may or may
not have a result of zero. If you set up the formula like this in that cell:
=IF(AND(A1=0,D5+D6=0),"",D5+D6)
But as I said, that's a little more complex and requires you to change all
existing formulas and to remember to 'wrap' any future formulas with the
IF(AND()) trap.

"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