copy/paste vaules, not formulas
 

Is there an easier way to copy and paste the values of a cell without using
notepad? When i paste directly to new column the formulas get copied--i
only want to paste the final values...
Makes sense?
Jeremy

--
Message posted via http://www.officekb.com

Copy. Choose Edit/Paste Special. Select the Values radio button. Click
OK.


In article ,
"jeremy via OfficeKB.com" wrote:

Is there an easier way to copy and paste the values of a cell without using
notepad? When i paste directly to new column the formulas get copied--i
only want to paste the final values...

ok, so when you paste to a new column, go to edit---paste special...
then click in the button values!

that should work! ;)


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=377544

JE
Thanks

--
Message posted via http://www.officekb.com

rae
thanks

--
Message posted via http://www.officekb.com

Hi Jeremy,
see http://www.mvps.org/dmcritchie/excel...houtformatting
for five methods more detail on the above page.
1) paste to formula bar, 2) use notepad, 3) Edit, Paste Special, values,
4) use Steve Miller's "Pure Text", 5) use a macro

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jeremy via OfficeKB.com" wrote in message ...
Is there an easier way to copy and paste the values of a cell without using
notepad? When i paste directly to new column the formulas get copied--i
only want to paste the final values...
Makes sense?
Jeremy

--
Message posted via http://www.officekb.com