ExcelBanter - How can I remove a formula from a cell and still have the value?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I remove a formula from a cell and still have the value? (https://www.excelbanter.com/excel-worksheet-functions/9239-how-can-i-remove-formula-cell-still-have-value.html)

Lannutslp

How can I remove a formula from a cell and still have the value?

I have a cell that is a formula and now that the formula has run I want to
convert the cell to just the value. Can this be done?

Niek Otten

EditCopy
EditPaste Special, check Values

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Lannutslp" wrote in message
...
I have a cell that is a formula and now that the formula has run I want to
convert the cell to just the value. Can this be done?

All times are GMT +1. The time now is 05:53 AM.