Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
De-activating null value display
Hi Experts,
I've learnt that I can go into options (under tools) to de-activate the display of zeros when null values are referenced. But whenever I navigate round the spreadsheet the option reverts to displayng zeros. Is this option a local setting on my pc, or is it part of the spreadsheet, or is it dependent on the worksheet being viewed? Is there a way of de-activating this forever? Tom PS: This is number 2 of a series of 3 questions that have been bugging me for ages. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
De-activating null value display
I've just discovered this answer in the General forum from papou which
answers my question. Hello You may consider creating an excel template (BOOK.XLT) with this option set to off and then place the tempate into the excel startup folder. HTH Cordially Pascal "ICTag" wrote: Hi Experts, I've learnt that I can go into options (under tools) to de-activate the display of zeros when null values are referenced. But whenever I navigate round the spreadsheet the option reverts to displayng zeros. Is this option a local setting on my pc, or is it part of the spreadsheet, or is it dependent on the worksheet being viewed? Is there a way of de-activating this forever? Tom PS: This is number 2 of a series of 3 questions that have been bugging me for ages. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box | New Users to Excel | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |