ExcelBanter - How do I convert the result of a formula in a field into a value

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

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

- - How do I convert the result of a formula in a field into a value (https://www.excelbanter.com/excel-worksheet-functions/168586-how-do-i-convert-result-formula-field-into-value.html)

Hicks

How do I convert the result of a formula in a field into a value

How Does one convert the result of a formula to a value -

Mike H

How do I convert the result of a formula in a field into a value

Hi,

Copy the result then

Edit|Paste special
select values and OK

Mike

"Hicks" wrote:

How Does one convert the result of a formula to a value -

Stephen[_2_]

How do I convert the result of a formula in a field into a value

"Hicks" wrote in message
...
How Does one convert the result of a formula to a value -

The result of a formula IS a value! Please explain what you mean.

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