Formula not displaying proper values when copying

[aaronnechama]

The strangest kind of error is happening - when I drag a cell containing a formula to the adjacent cell - the formula copies properly but the value that is displayed changes to the ACTUAL contents of the originating cell.
For example, if I create a formula

=PROPER(A2)

in cell B2 and then drag to copy into cell B3, the formula that is copied changes to the relative reference of

=PROPER(A3)

, but the value that is displayed remains the same as in cell B2, meaning it does not change to the relative reference. This is the strangest error I have ever seen.

See the following image for the error.

 

[VoG]

Check that calculation is set to Automatic - Tools > Options > Calculation tab.

 

[aaronnechama]

That did it! Thanks Peter.