Think the switch off zeros setting should stick. Just tested it here. But
what probably happens is that when we open another window, and then we click
on the same sheet in this new window, the zeros are there again (but in this
new window). If we were to click on the same sheet in the 1st window, you'll
see that the switch off zeros setting is still there. Hence if we operate the
file using 2 windows, we'll need to apply the setting to both windows for the
same sheet. If we close one of the 2 windows, then re-create it, we'll have
to apply the setting again.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeel" wrote:
Thank you for your help. I tested it a little and it looks like it is going
to work.
Perhaps you could help me with another problem I posted.
I want to remove the zeroes from my worksheet. I click the microsoft button,
excel options, advanced and uncheck the box for show zeroes. I save when I
close but when I open the workbook again the zeroes are there again. Is there
a way to set the default so the zeroes won't show and I would have to check
the box to show them? Thank you.