replaces formula to its value

[InspectorJim]

F2,F9,ENTER should replace a formula with its value. For some reason, the
Excel I am using at work does not function when I do that. Formula remains as
if I didn't do anything. I've done it before succssfully on other Excel
programs. Any ideas why this might not work? Are there some settings I could
have missed that might be preventing the F2,F9,ENTER from working? I am using
a Microsoft keyboard, wireless, 6000 V.3. Excel is within Office 12.

 

[Teethless mama]

Tools > Options > Calculation > select Automatic > OK out