Converting functions into numbers

V

vesuvius

For example, using the function =2*3, I will get a 6 in the cell.

Now I would like to copy the 6 into another cell.

Using the usual copy, I will copy the function.

Is there a way that I can copy the 6 as a number and not as a function
 
P

p6er

Assumed you had the formula in cell A1 and you want your value copied to
C1, insert the '=A1' into cell C1. However, if A1 changes, C1 certainly
will change as well.
 
V

vesuvius

hiya, yeah, but that will copy the function as well :(

my intention is

(i) to copy the cell's number value, without copying the function
(ii) to store the cell's number value which is derived from the
function, while removing the function

can I do that?
 
Top