| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Value replaces formula result when file is opened. But why? | Excel Discussion (Misc queries) | |||
| I desperately miss Report Manage in Excel - what replaces it in 2 | Excel Discussion (Misc queries) | |||
| Opening a second worksheet replaces the current | Excel Discussion (Misc queries) | |||
| How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
| Zero replaces blank field when paste special is used | Excel Worksheet Functions | |||
Linear Mode
