EXCEL2000 trouble with SUM function recalculating on new data ent
 

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.

EXCEL2000 trouble with SUM function recalculating on new data ent
 

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

--
Regards,
Dave


"huskybytes" wrote:

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.

EXCEL2000 trouble with SUM function recalculating on new data
 

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.

"David Billigmeier" wrote:

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

--
Regards,
Dave


"huskybytes" wrote:

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.