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

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

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