replaces formula to its value
 

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.

replaces formula to its value
 

Tools Options Calculation select Automatic OK out


"InspectorJim" wrote:

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.