Excel Cell format Question??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I change the default value of a cell from 0 to a different number?
 
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
 
You must log in or register to reply here.

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

Question about conditional formatting of zeros in Excel 0
Default number format in Excel 1
Entering 'GTi' but I get 'Gti' ! 2
Red cell for negative numbers in Excel 1
Custom Number Format for text 8
Displaying zeros in cells 2
For Joey2004 et al. From OP: Re Appending Question 3
Excel VBA 1

Back
Top