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. |
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 |