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

L

Lannutslp

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?
 
N

Niek Otten

Edit>Copy
Edit>Paste Special, check Values

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
Drop down list control value in vba 2
Merging from an Excel file with graphics 1
Is there a function to count how many times a cells value is used? 0
Applying a formula to multiple values within a single cell? 1
Excel does not accept text format! 0

Top