A cell has no default number unless you placed it there.
OR........do you mean if you enter a formula such as =12*A1 you get 0 if A1
is empty?
You could use an IF in your formula.
=IF(A1="",yournumber,12*A1) where yournumber is whatever you wish it to be.
Gord Dibben Excel MVP
