copy cell contents but not formula

Cell B1 has a number which is created by a formula. I
would like to copy the value in cell B1 to C1 but I do not
want to copy the formula. Is this possible? Thanks for
your assistance.

Copy it as usual, but when you are ready to paste it, go to editpaste
special and check 'values'.



"newbie" wrote in message
...
Cell B1 has a number which is created by a formula. I
would like to copy the value in cell B1 to C1 but I do not
want to copy the formula. Is this possible? Thanks for
your assistance.

Hi
in C1 simply enter
=B1

--
Regards
Frank Kabel
Frankfurt, Germany

"newbie" schrieb im Newsbeitrag
...
Cell B1 has a number which is created by a formula. I
would like to copy the value in cell B1 to C1 but I do not
want to copy the formula. Is this possible? Thanks for
your assistance.

In article ,
"newbie" wrote:

Cell B1 has a number which is created by a formula. I
would like to copy the value in cell B1 to C1 but I do not
want to copy the formula. Is this possible? Thanks for
your assistance.

Hi,

Select your cell (B1) edit copy
select your destination cell (C1)
Edit Paste Special Values

Cheers!

-----Original Message-----
Cell B1 has a number which is created by a formula. I
would like to copy the value in cell B1 to C1 but I do
not
want to copy the formula. Is this possible? Thanks for
your assistance.
.
try copy paste special -values.

try "copy", "paste special", "value"