Copy formulas not working

[Dave Stitz]

I am trying to copy simple formulas in a spreadsheet and Excel appears to
only be copying the values. But when I go to the cell, it has the correct
formula, but the wrong result. I have not seen this before...can anyone
help?? The formula I copy has the same result in ever cell but they are
wrong.

Frustrated.

 

[David Biddulph]

Tools/ Options/ Calculation:
se it to Automatic.