| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero values to show blank
Hi all
I have formulas on my worksheet and several of the 'answers' are zero, which is correct, however, I want to format the whole worksheet so rather than displaying '0', it simply leaves the cell blank. How would I do this? Thanks. Louise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| =IF cell needs to show blank if blank | Excel Discussion (Misc queries) | |||
| show blank instead of #N/A | Excel Discussion (Misc queries) | |||
| zero values in charts-don't want to show as zero, but as blank | Excel Discussion (Misc queries) | |||
| Needs to Show blank please | Excel Worksheet Functions | |||
Threaded Mode
