The issue here is everytime I export my tracking from Shipstation, it exports the CSV Only so the tracking in Column V shows as Scientific Format, Is there any way I can Create a button on the spreadsheet that i can press so it can show the full tracking number ?
I have attached a File for your reference.
Any Help is greatly appreciated!
You need to import the column as text to prevent the conversion to a number. Change the file extension to .txt, and import using the import wizard.
Entia non sunt multiplicanda sine necessitate
Would I be able to make a Macro Button to Convert them automatically since i will be doing this often ?
In Cell View
It is 11 Digits
More than 11 Digits will show as 1.23457E+11 in the cell
In Formula Bar View
Upto 15 digits will show as it is
More than 15 Digits it will convert the subsequent number entries as show as 0 zeros.
Addition of digits more than 15 to 21 will be automatically treated as zeros.
More than 21 digits then it will retain the 15 digits and replace all the zeros with + and set the first number as integer and move the rest of the digits in the decimal area and add the length of that number in the end.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
HI Sixthsense,
Would I be able to create a Macro so i can convert these to their usual form ?
No you can'tOriginally Posted by Fredbugatti
Because after 15 digits your original numbers are converted as zero.
Follow shg method on Post #2 which is the only way you have to go...
Because you can control the data at the time of exporting once you exported the Numerical data into excel (Which have more than 15 digits) as real numbers then you don't have any control over it
It is actually not working when I try Importing it from Text on a different spreadsheet, would you please do it and see if it works ?
I followed shg suggestion and just changed the extension to .txt
Refer the attached notepad file
Hmmm, The Tracking still doesnt show fully when I open the try importing the text file through an Excel File by going to Data- From Text- Delimited-Selecting Tab and Comma ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks