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?


--
vesuvius
------------------------------------------------------------------------
vesuvius's Profile: http://www.excelforum.com/member.php...o&userid=28575
View this thread: http://www.excelforum.com/showthread...hreadid=482371

Sorry to bump the board, but I really need help fast


--
vesuvius
------------------------------------------------------------------------
vesuvius's Profile: http://www.excelforum.com/member.php...o&userid=28575
View this thread: http://www.excelforum.com/showthread...hreadid=482371

Copy PasteSpecial Values

Vaya con Dios,

Chuck, CABGx3


"vesuvius" wrote in
message ...

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?


--
vesuvius
------------------------------------------------------------------------
vesuvius's Profile:
http://www.excelforum.com/member.php...o&userid=28575
View this thread: http://www.excelforum.com/showthread...hreadid=482371

brilliant! thanks a lot CLR :D


--
vesuvius
------------------------------------------------------------------------
vesuvius's Profile: http://www.excelforum.com/member.php...o&userid=28575
View this thread: http://www.excelforum.com/showthread...hreadid=482371

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.


--
p6er
------------------------------------------------------------------------
p6er's Profile: http://www.excelforum.com/member.php...o&userid=28571
View this thread: http://www.excelforum.com/showthread...hreadid=482371

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?


--
vesuvius
------------------------------------------------------------------------
vesuvius's Profile: http://www.excelforum.com/member.php...o&userid=28575
View this thread: http://www.excelforum.com/showthread...hreadid=482371