Copy/Paste limit?
 

I copied a column of Mainframe data to Excel and any numbers with 6 digits
plus the thousand comma separator will somehow transposed into another widely
different number. All 5 digits and less plus the thousand comma separator
worked fine. Is there a setting that triggers Excel to do this or is it
simply a bug? Thanks!

Copy/Paste limit?
 

I've never seen excel do this.

You may want to post the actual value that you're copying and pasting (before
and after versions, too).

ka2cil wrote:

I copied a column of Mainframe data to Excel and any numbers with 6 digits
plus the thousand comma separator will somehow transposed into another widely
different number. All 5 digits and less plus the thousand comma separator
worked fine. Is there a setting that triggers Excel to do this or is it
simply a bug? Thanks!

--

Dave Peterson