| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy & paste numbers instead of formula
I am moving data from one place in a file to another. (I DON'T want to
reference the cells, I want to be able to copy & paste) the problem is that the cells I'm copying contain formulae and what I want is to copy and paste the visible numbers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy & paste numbers instead of formula
Copy Paste special Check "Values" OK
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "AmmHan" wrote: I am moving data from one place in a file to another. (I DON'T want to reference the cells, I want to be able to copy & paste) the problem is that the cells I'm copying contain formulae and what I want is to copy and paste the visible numbers. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy & paste numbers instead of formula
AmmHan
CopyPaste SpecialValues Mike Rogers "AmmHan" wrote: I am moving data from one place in a file to another. (I DON'T want to reference the cells, I want to be able to copy & paste) the problem is that the cells I'm copying contain formulae and what I want is to copy and paste the visible numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't copy/paste the formula | Excel Discussion (Misc queries) | |||
| Copy / Paste Formula | Excel Discussion (Misc queries) | |||
| How do i copy numbers from Web and paste to excel and and get tota | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| why cant I copy and paste a formula? | Excel Discussion (Misc queries) | |||
Linear Mode
