| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace zeros with nulls
This is a nice one to keep in your mental toolbox. If you want to display
the fact that data is missing, then leave the blanks in. If you want better looking plots, then filter them out. -- Gary's Student "dharshanie" wrote: Thank You!!! That's great-will have a go. -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| Replace #DIV/0 error with zeros | Excel Discussion (Misc queries) | |||
| replace values with zeros | Excel Discussion (Misc queries) | |||
| How can I replace zeros with blank spaces during calculations plea | Excel Worksheet Functions | |||
| Using Excel, how do I replace cells containing blanks with nulls? | Excel Discussion (Misc queries) | |||
Threaded Mode
