Tracking numbers get converted to Scientific numbers:
When generating Ship Confirmation report, the Tracking number gets converted to scientific format. This is because Excel automatically converts a long string of numbers.
Workaround would be to:
- save the file as .txt
- open in Excel using the text file import wizard
- checkmark the comma, go to next
- click on the column with the tracking number and change the column type to Text
- click Finish.
The numbers will be then treated as text and it will no be converted to scientific numbers.