Convert function to value
 

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.

Convert function to value
 

Copy, then Edit/ Paste Special/ Values.
--
David Biddulph

"JC" wrote in message
...
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.