L
L/P
How do you set up a cell so when there is no value, a "0" or "-" will
auto-fill cell?
Thanks,
L.
auto-fill cell?
Thanks,
L.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi L,
What do you mean by auto-fill?
Biff
What do you mean by auto-fill?
Biff
L
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.
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.
P
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
select yout range, press F5, click Special,
select Blanks, click OK. Press Ctrl + V
D
Dave Peterson
Another way.
Select your range
F5, special
type 0
hit ctrl-enter instead of enter.
Select your range
F5, special
type 0
hit ctrl-enter instead of enter.