never show zeros.
 

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

never show zeros.
 

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

never show zeros.
 

Select all sheets in a workbook go to options and do as you mentioned. Save
the workbook as template. Next time open the template. The changes you made
are there.

"RolfeH" 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