It's a setting that needs to be changed:

<Tools <Options <Edit tab,
And *UNCHECK*
"Extend List Formats & Formulas".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"jecameron" wrote in message
...
I'm using Excel 2003

I have values in cells A1, B1 and C1

I have a formula in cell G1: =SUM(A1:C1)

I type a value in cell D1 and Excel 2003 automatically changes the formula
in cell G1 to =SUM(A1:D1), without any notification

How can I prevent this automatic changing of the formula in cell G1?