Auto-Fill blank cell with 0?

  • Thread starter Thread starter L/P
  • Start date Start date
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.
 
(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.
 
One way, put zero in an empty cell, copy it,
select yout range, press F5, click Special,
select Blanks, click OK. Press Ctrl + V
 
Another way.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
Auto fill typing in cells problem 2
Auto Fill Down Macro 5
Excel VBA 1
Conditional Formatting 3
Macro Fill Formula 1
=text(a1,"dddd") question 10
Displaying zeros in cells 2

Back
Top