Auto-Fill blank cell with 0?

[L/P]

How do you set up a cell so when there is no value, a "0" or "-" will
auto-fill cell?

Thanks,

L.

 

[Biff]

Hi L,

What do you mean by auto-fill?

Biff

 

[L/P]

(Sorta new to Excel)
Put together a spread sheet and some of the cells have no numeric values.
Would like the "empty" cells to fill with 0(zero) or -(dash) automatically,
if possible..

L.

 

[Peo Sjoblom]

One way, put zero in an empty cell, copy it,
select yout range, press F5, click Special,
select Blanks, click OK. Press Ctrl + V

 

[Dave Peterson]

Another way.

Select your range
F5, special
type 0
hit ctrl-enter instead of enter.