EXCEL2000 trouble with SUM function recalculating on new data ent

H

huskybytes

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.
 
D

David Billigmeier

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
 
H

huskybytes

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.
 
Top