| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can I set the default for "show zeroes" to not show the zeroes?
The default for showing zeroes in worksheets is to show them. I seem to have
to uncheck the box everytime I work with the worksheet. Is there a way to reset the default to not show the zeroes? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Can I set the default for "show zeroes" to not show the zeroes?
That is a Window only option so each sheet has to be unchecked.
Without creating a default Template for all NEW workbooks or adding workbook_open code to existing workbooks, there is no way to change the default. Gord Dibben MS Excel MVP On Thu, 24 Jan 2008 20:38:01 -0800, jeel wrote: The default for showing zeroes in worksheets is to show them. I seem to have to uncheck the box everytime I work with the worksheet. Is there a way to reset the default to not show the zeroes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro | Excel Discussion (Misc queries) | |||
| Problem: zeroes added to "general" format cell | Excel Worksheet Functions | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Linear Mode
