Try:

tools|option|calculation tab|check automatic.

Excel User wrote:

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