Strange copy/paste formula problem

**thestappa** · 10-29-2010, 05:22 PM

I am trying to add a column to my spreadsheet that grabs the right two characters of a different cell. I use the simple formula

Please Login or Register  to view this content.

in column L and it works. The value I get in Cell L2 is 21 which is correct. When I try to copy and paste that cell down to all the remaining rows it enters 21 into every row, regardless of what is in column M. For example, for row 80 the value in M is 0022, but L is showing 21. The formula in cell L80 is

Please Login or Register  to view this content.

so it's copying the formula properly, just not displaying the correct value. If I type in the formula into L80 directly, it works (returns 22).

I'm new to excel 2007.

**TMS** · 10-29-2010, 05:38 PM

Sounds as though calculation is set to Manual. Press F9 and see what happens.

Check your setup and make sure that Calculation is set to Automatic.

Regards