thank you all so very much it worked for a while yet it is still doing it
the formula has changed the original column say my original formula is =sum($B3*C15) I would like the same formula along the rest of the row being ($B3&d15),b3*e15, b3*f15 etc.... but its not working it will change the formula