problem with formulas

[simon]

For some reason when i try and copy a formula to a
different cell, it carries forward the sum of the cell
being copied! The only way around it is to edit the
formula and press enter...

A strange one, neaver had it before