Insert "0" where null

[MSWEENEY]

I want to do something that is probably simple. I have a worksheet
with a lot of empty cells. I want a "0" inserted into every cell that
is empty or null.

How do I do that?

 

[Beege]

MSWEENEY

Select the range in question (if you do the entire sheet, it will take lots
of time and memory)

Edit/Replace (leave blank) with 0, match entire cell.

Beege

 

[Guest]

It depends..........if your "empty" cells are just that, "empty" having
nothing in them at all, then just copy and paste zeros into them..........it
they are empty by result of formulas using the "" entry, then just replace it
with a 0 in the formulas........

Vaya con Dios,
Chuck, CABGx3

 

[Ken Wright]

Select the entire range, do Edit / Go To / Special / Blank Cells Only, then
type a 0 and hit CTRL+ENTER to enter it into every blank cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------