Tools/ Options/ Calculation:
se it to Automatic.
--
David Biddulph

"Dave Stitz" wrote in message
...
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.