Always Disable 'Zero Values'

[krissz]

Hi
I am looking for a way that I can ensure that Zero Values are never shown, either when you open a new workbook or open a new window.
Preferable, one which I can install for any user who needs this. (such as via Book.XLA I think) but AutoExec is fine as long as it is alwys loaded.
Thank you in advance

 

[ArthriticPanda]

Hi Krissz,

You can actually 'switch off' the display of zero values in a workbook and save it. That way it will open in the same state. Which version of excel are you using?

AP