This is a worksheet setting only, not a workbook or global setting.

For all new workbooks and worksheets you could create new default book and
sheet templates.

For existing books............run a macro to set on all sheets.


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 13:16:47 -0800, RolfeH
.(donotspam) wrote:

how do I globally turn off "zeros". I can go to "Excel Options, Advanced,
show a zero in cell that have zero value" and "uncheck it" but, I have to do
it on every file I open. Can I have it ALWAYS turned off??
thanks,
RolfeH