Paste vs. Paste Special 
Author Message
 Paste vs. Paste Special

What is the difference between Paste and Paste Special
(text)?  I am attempting to copy a series of numbers from
Mainframe into Excel 2002, when I paste them into Excel a
number is pasted, but it looks nothing like the number I
copied from Mainframe.  I've found that if instead of
doing a straight paste, I do a paste special and
select 'text', it pastes into Excel correctly.


Sat, 13 Aug 2005 21:25:38 GMT  
 Paste vs. Paste Special
Depends on the data you are copying really - You don't give an example of
what it is doing, but it is possible that you are copying data with hyphens
in that look like dates and being interpreted as such by Excel, in which
case it will 'Help' you by changing the data to the format you 'really want'

If you are copying numbers that exceed 15 digits you may see a rounding of
those numbers due to Excel limiting itself to 15 significant figures.

You may also simply have a number like 123456789123 that gets changed to
something like 1.23457E+11 - If so then simply format the cells to a number
format as opposed to General.

If none of the above then post back with a few more details.

--
Regards
           Ken.......................  Win XP /  XL2K & XLXP

----------------------------------------------------------------------------
Public Service Request - It is very much appreciated
in text-only groups if you don't attach files - Thanks
----------------------------------------------------------------------------


Quote:
> What is the difference between Paste and Paste Special
> (text)?  I am attempting to copy a series of numbers from
> Mainframe into Excel 2002, when I paste them into Excel a
> number is pasted, but it looks nothing like the number I
> copied from Mainframe.  I've found that if instead of
> doing a straight paste, I do a paste special and
> select 'text', it pastes into Excel correctly.



Sat, 13 Aug 2005 21:44:17 GMT  
 Paste vs. Paste Special
The data being copied is straight 10 digit numbers.   I
have included a table below that shows some of the numbers
that I tried pasting into Excel with odd results.  I don't
understand it, the second number in the table pasted
correctly but the others did not and I repeated the
process to verify the problem.

        Value Pasted
Original Number Result when pasted
                   Into Excel

3658727835             49563
5063655614             5063655614
2373898876             53884
3528595968             6656

I tried pasting these same numbers into Lotus 1-2-3 and
they copied over fine.

Quote:
>-----Original Message-----
>Depends on the data you are copying really - You don't
give an example of
>what it is doing, but it is possible that you are copying
data with hyphens
>in that look like dates and being interpreted as such by
Excel, in which
>case it will 'Help' you by changing the data to the

format you 'really want'
Quote:

>If you are copying numbers that exceed 15 digits you may
see a rounding of
>those numbers due to Excel limiting itself to 15

significant figures.
Quote:

>You may also simply have a number like 123456789123 that
gets changed to
>something like 1.23457E+11 - If so then simply format the
cells to a number
>format as opposed to General.

>If none of the above then post back with a few more
details.

>--
>Regards
>           Ken.......................  Win XP /  XL2K &
XLXP

>----------------------------------------------------------
------------------
>Public Service Request - It is very much appreciated
>in text-only groups if you don't attach files - Thanks
>----------------------------------------------------------
------------------


message

>> What is the difference between Paste and Paste Special
>> (text)?  I am attempting to copy a series of numbers
from
>> Mainframe into Excel 2002, when I paste them into Excel
a
>> number is pasted, but it looks nothing like the number I
>> copied from Mainframe.  I've found that if instead of
>> doing a straight paste, I do a paste special and
>> select 'text', it pastes into Excel correctly.

>.



Sat, 20 Aug 2005 13:48:43 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Update Excel Chart on Access Form Created from Paste Special (Paste as a Link)

2. Replace Paste with Paste Special

3. Update Excel Chart on Access Form Created from Paste Special (Paste as a Link)

4. pasting spreadsheets into Word using Paste Special

5. Can cut or copy Can Not select paste or paste special

6. Macro paste, now paste special?

7. MS Application errors: Paste, Paste Special / Insert, Objects...

8. paste special or paste

9. Force paste to be paste special?

10. Insert Object vs Paste Special


 
Powered by phpBB® Forum Software © phpBB Group