Jun 23 2004, 06:26 PM
I have a tracking number that is 22 characters in length which is being copied from a warehouse database system and I want to paste it into an excel spreadsheet.
What I get when I paste is this .... 9.61E + 21
How come I cannot just enter in all 22 numeric characters and not have excel re-format it some other way?
Jun 23 2004, 07:31 PM
change the Cell format to text
Jun 23 2004, 10:24 PM
Thanks but there is still some problem. The string goes to all zeroes after 15 digits.
Any other ideas?
Jun 23 2004, 11:20 PM
an idea would be ...before moving data into Excel, create a new field based on your original 22numeric field and add an ' before. So 12345... will be '12345.... This way Excel will see those values as text.
Jun 24 2004, 02:47 AM
I do appreciate that ... and that does work.
Jun 24 2004, 07:01 AM
You're very welcome!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here