software

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.

It's probably because the data used to be stored as text. Simply changing
the format to a number (in the lt;Formatgt;lt;Cellsgt; menu) won't update your
formula. Try this:

Copy an empty cell
Select your range
Paste Special-gt;Add

--
Regards,
Davequot;huskybytesquot; wrote:

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

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.

quot;David Billigmeierquot; wrote:

gt; It's probably because the data used to be stored as text. Simply changing
gt; the format to a number (in the lt;Formatgt;lt;Cellsgt; menu) won't update your
gt; formula. Try this:
gt;
gt; Copy an empty cell
gt; Select your range
gt; Paste Special-gt;Add
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;huskybytesquot; wrote:
gt;
gt; gt; I have a Sum function at the end of each row. When I enter the new monthly
gt; gt; number, it doesn't recalculate. F9 has no effect. If I change Sum (B1:m1)
gt; gt; to
gt; gt; =B1 C1 D1... it calculates correctly. I checked the data type to be Number,
gt; gt; 0 Decimals for all cells.