try this

select the range | press F5 | click special | choose blanks | ok |
enter 0 and hit ctrl + enter



On Sep 25, 1:59*pm, donpayette
wrote:
I have a spreadsheet (500ishx40ish) that either has *a number 0 or a blank.
*I need to go through and insert a "0" in any cell that is blank. *I cannot
come up with any conditional processing to do this and would like to avoid
having to manually go through all these cells and enter "0" where needed.

Suggestions? *

Thanks!
Don