| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I delete the formula but keep the results
How do I delete the formula in the formula bar and keep the results from that
formula in a column. I read how to do this last week on this forum but now I can't find the answer!!!!!!!!!. |
|
#2
|
|||
|
|||
|
Hi
Select the cell Press F2 and then F9 -- Regards Ron de Bruin http://www.rondebruin.nl "Paul K." wrote in message ... How do I delete the formula in the formula bar and keep the results from that formula in a column. I read how to do this last week on this forum but now I can't find the answer!!!!!!!!!. |
|
#3
|
|||
|
|||
|
Or for a range: select the range and use Copy,
then, without deselecting the range, use Edit|Paste Special and specify Values -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ron de Bruin" wrote in message ... Hi Select the cell Press F2 and then F9 -- Regards Ron de Bruin http://www.rondebruin.nl "Paul K." wrote in message ... How do I delete the formula in the formula bar and keep the results from that formula in a column. I read how to do this last week on this forum but now I can't find the answer!!!!!!!!!. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My DCOUNTA formula results do not display in Excel. | Excel Worksheet Functions | |||
| Can I Delete Symbol in Cell That Has A Formula? | Excel Discussion (Misc queries) | |||
| Formula results. | Excel Worksheet Functions | |||
| If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Linear Mode
