software

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

--

Dave Peterson

quot;Excel Userquot; lt;Excel gt; wrote in message
...
gt; For instance, in cell H40 i have a value of $3000. In another part of the
gt; worksheet i have a cell that contains the simple formula of =H40. But the
gt; anwers is 0. In fact any formula i try becomes zero. This is a worksheet
gt; i
gt; have been working with for quite some time with no problems. I had to
gt; change
gt; the value in cell H40 many times and it would always show up correctly in
gt; the
gt; =H40 cell. All of the sudden everytime a alter a cell that is connected
gt; to a
gt; 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
I am having the same problem as the original post. I have a spreadsheet I've been using for weeks now, adding data each day, and suddenly every calculated cell that I edit (most are filled with formulas like =A1/A2) ends up zero! Even previously working cells, if I hit F2, but don't change anything and just hit enter, then suddenly the cell value is zero!

I tried Dave Peterson's suggestion below, changing these settings, but that didn't fix it. There must be some setting that is doing this! I even created a new empty spreadsheet and get the same behavior.

Here are the contents below of the test spreadsheet, starting in cell A1, with the contents of formulas in cells A3 through A7 shown in text in B3 through B7. This has to be really simple. But what???

100Content of cells in column A
100A1 and A2 are 100
0=A1/A2
0=100/100
0=200/100
0=1
0=SUM(A1:A2)

Originally Posted by Dave PetersonTry:

tools|option|calculation tab|check automatic.

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

--

Dave PetersonI have some additional data points:
1) I created another new spreadsheet, and mysteriously, it was behaving as expected. For example, simple equations like =100 200 indeed showed a value of 300. In my problem spreadsheet, that cell would be 0.
2) This information I think may be material (for those of you who know) - When I cut amp; paste from the problem spreadsheet to a new spreadsheet file, it only pastes as if I was selecting quot;Paste Special by Valuequot;. All of the formulas disappear. And if I do try quot;Paste Special by Valuequot; it gives me choices as if I'm pasting the whole file. The first choice is quot;Microsoft Office Excel Worksheet Objectquot;. Excel is acting like the problem file is NOT an Excel file.

Very strange!

QUOTE=MarkBohrer;959641]I am having the same problem as the original post. I have a spreadsheet I've been using for weeks now, adding data each day, and suddenly every calculated cell that I edit (most are filled with formulas like =A1/A2) ends up zero! Even previously working cells, if I hit F2, but don't change anything and just hit enter, then suddenly the cell value is zero!

I tried Dave Peterson's suggestion below, changing these settings, but that didn't fix it. There must be some setting that is doing this! I even created a new empty spreadsheet and get the same behavior.

Here are the contents below of the test spreadsheet, starting in cell A1, with the contents of formulas in cells A3 through A7 shown in text in B3 through B7. This has to be really simple. But what???

100Content of cells in column A
100A1 and A2 are 100
0=A1/A2
0=100/100
0=200/100
0=1
0=SUM(A1:A2)[/quote]