| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get zeros to show after decimal point? | Excel Worksheet Functions | |||
| Don't show zeros or #N/A in Column Chart | Charts and Charting in Excel | |||
| Show leading zeros. | Excel Discussion (Misc queries) | |||
| How do I show zeros? | Excel Discussion (Misc queries) | |||
| Lead Zeros to Show? | Excel Worksheet Functions | |||
Linear Mode
