never show zeros.

[RolfeH]

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

 

[Gord Dibben]

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

 

[Khoshravan]

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.