| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula results.
In excel how do I remove a formula and leave just the resultant value in that
cell? I'm fairly sure that there is a way to "remove" the formula and keep just the value but, I can't seem to find it now. Thanks, Pete. |
|
#2
|
|||
|
|||
|
Hi
Select the cell, type Ctrl+C (copy) and then click on Edit/Paste Special/Values. -- Andy. "PeterP" wrote in message ... In excel how do I remove a formula and leave just the resultant value in that cell? I'm fairly sure that there is a way to "remove" the formula and keep just the value but, I can't seem to find it now. Thanks, Pete. |
|
#3
|
|||
|
|||
|
Copy - Paste Special-Values
"PeterP" wrote in message ... In excel how do I remove a formula and leave just the resultant value in that cell? I'm fairly sure that there is a way to "remove" the formula and keep just the value but, I can't seem to find it now. Thanks, Pete. |
|
#4
|
|||
|
|||
|
1)Click on the cell
2)press [F2] (edit) 3)Press [F9] (calc) 4)Press [Enter] OR 1)Click on the cell 2)EditCopy 3)EditPaste SpecialValues Does that help? Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula or not? | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| Polynimial trandline formula | Charts and Charting in Excel | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Hybrid Mode
