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.