Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block deleting all zeros at once.
In Excel2003 Is there a way of block deleting all zero
values from 3 columns of data. If not could anyone suggest a function to do this. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block deleting all zeros at once.
Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block deleting all zeros at once.
Oh, be sure to select the range before you do this or the entire sheet will
be searched. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows containing zeros | Excel Discussion (Misc queries) | |||
Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
Deleting Lead Zeros | Excel Worksheet Functions |