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

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.

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

"Excel User" <Excel User@discussions.microsoft.com> wrote in message
news:3B28082F-7591-460C-8BB0-7D279FA36EE7@microsoft.com...
> 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.
--
David Biddulph