ExcelBanter - how do i change a formula to its value

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

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

- - how do i change a formula to its value (https://www.excelbanter.com/excel-worksheet-functions/149679-how-do-i-change-formula-its-value.html)

Davy

how do i change a formula to its value

After a range has calculated the answer from a formula, how can I change the
same range to the value displayed?

Teethless mama

how do i change a formula to its value

Select your range copy paste special values OK

"Davy" wrote:

After a range has calculated the answer from a formula, how can I change the
same range to the value displayed?

Peo Sjoblom

how do i change a formula to its value

Copy and paste special as values

--
Regards,

Peo Sjoblom

"Davy" wrote in message
...
After a range has calculated the answer from a formula, how can I change
the
same range to the value displayed?

All times are GMT +1. The time now is 09:47 PM.