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? |
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? |
All times are GMT +1. The time now is 06:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com