Replace empty cell with zero, leave data untouched

[Sfinally]

Is there a formula that I can copy into a column that has existing numbers/formulas (but only on some lines) that puts a zero into all of the empty cells and leaves the cells with data untouched?

 

[Blade Hunter]

Put a 1 on a blank cell

Copy the cell and then highlight the range you want to have the zeros in.

Click edit then paste special.

Tick multiply and hit ok.

Delete your 1

I only learned this a couple of days ago on this very forum