| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacing 0 with blank
Further to my previous message I kept trying & GOT IT TO WORK.
In my particular case IF((B2:M32 0),B2:M32*3.936996," ") This changes my old rain charts measured in 1/100 of an inch to millimetres & leaves the blanks blank rather than replacing them with 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding and replacing text with a blank | Excel Discussion (Misc queries) | |||
| Replacing blank cells with zeros | Excel Discussion (Misc queries) | |||
| prevent copied blank cells from replacing existing data | Excel Worksheet Functions | |||
| Replacing blank cells | Excel Worksheet Functions | |||
| Replacing 0 with blank | Excel Programming | |||
Linear Mode
