ExcelBanter - convert formula to its value

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert formula to its value (https://www.excelbanter.com/excel-discussion-misc-queries/10718-convert-formula-its-value.html)

Andrea

convert formula to its value

I have column made up of formulas that I want to convert
the formula to it's value. Is this an option in Excel

Robin Hammond

Copy the range, then edit, paste special, values.

Robin Hammond
www.enhanceddatasystems.com

"Andrea" wrote in message
...
I have column made up of formulas that I want to convert
the formula to it's value. Is this an option in Excel

Rob van Gelder

Yes,

Highlight the range of cell, select Copy.
From the Edit menu, select Paste Special. Choose Values.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Andrea" wrote in message
...
I have column made up of formulas that I want to convert
the formula to it's value. Is this an option in Excel

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