| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing 0 with blank
I have a number of worksheets with many 0 cells. I wish to replace the
0 cells with blank. If I use replace 0 with blank it also changes the 10,20 etc to 1,2 by removing the 0. I have tried searching for 0 with a leading blank, using various functions & just about run out of ideas. I am NOT an Excel expert & would appreciate any help |
| 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 #DIV/0! With Just 0 | Excel Worksheet Functions | |||
Threaded Mode
