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
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#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) |