Why are all of my formulas in Excel are giving the anwser zero?

[Guest]

For instance, in cell H40 i have a value of $3000. In another part of the
worksheet i have a cell that contains the simple formula of =H40. But the
anwers is 0. In fact any formula i try becomes zero. This is a worksheet i
have been working with for quite some time with no problems. I had to change
the value in cell H40 many times and it would always show up correctly in the
=H40 cell. All of the sudden everytime a alter a cell that is connected to a
formula, the answer becomes zero.

 

[Dave Peterson]

Try:

tools|option|calculation tab|check automatic.

 

[David Biddulph]

For instance, in cell H40 i have a value of $3000. In another part of the
worksheet i have a cell that contains the simple formula of =H40. But the
anwers is 0. In fact any formula i try becomes zero. This is a worksheet
i
have been working with for quite some time with no problems. I had to
change
the value in cell H40 many times and it would always show up correctly in
the
=H40 cell. All of the sudden everytime a alter a cell that is connected
to a
formula, the answer becomes zero.

My guess is that your H40 cell is now formatted as text, and hence being
regarded as a value of zero. I would suggest that you put it back to the
format it had when it was working.