Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
sum limit and marking | Excel Worksheet Functions | |||
Make the row limit of excel flexible -not fixed at 65536. | Excel Discussion (Misc queries) | |||
Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) |