EXCEL2000 trouble with SUM function recalculating on new data ent

[Guest]

I have a Sum function at the end of each row. When I enter the new monthly
number, it doesn't recalculate. F9 has no effect. If I change Sum (B1:m1)
to
=B1+C1+D1... it calculates correctly. I checked the data type to be Number,
0 Decimals for all cells.

 

[Guest]

It's probably because the data used to be stored as text. Simply changing
the format to a number (in the <Format><Cells> menu) won't update your
formula. Try this:

Copy an empty cell
Select your range
Paste Special->Add

 

[Guest]

I inserted a new row for 2006 montly utility usage. When I deleted the entry
for B2 and re-entered (the same number) miraculously, the function works
again. There must be something wrong and I'm too cheap to upgrade from my
student version of Office 2000 but thanks David.