ExcelBanter - Convert function to value

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

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

- - Convert function to value (https://www.excelbanter.com/excel-discussion-misc-queries/136420-re-convert-function-value.html)

Max

Convert function to value

Just do an in-place: Copy Paste special Check "Values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JC" wrote:
Is there a way to convert a range of cells which currently contain functions
(returning numeric values) to the value returned?

For example:

a1 = 5
a2 = a1 * 2 (returns 10)

How to convert a2 to the number 10, instead of the function?

thanks.

All times are GMT +1. The time now is 10:45 AM.