View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
paravicini paravicini is offline
external usenet poster
 
Posts: 1
Default excel changes my formula

The formula in column F of my worksheet is =SUM(A1:C1)
It recalculates the value as I enter date into these columns. As soon as I
enter date in columns D, E, or F, the formula is changed to inlcude them.

I total these in column G =SUM(D1:F1)

Why is my formula being changed and how can I stop it?