In ShippingEasy, our CSV downloads will have an appostrophe ' before each tracking number. This is because spreadsheets will automatically truncate this number.
If you would like to omit this, just select the column on the spreadsheet, then do CTRL+F (for Windows) or COMMAND+F (for Mac) and "Find" ' and leave the "Replace" value blank.
This will cause the numbers to truncate. To change this, change the column format from "General" or "Number" to "Text".
Related articles:
How to: Merge multiple columns of data in Excel without losing any data
How to: Export tracking numbers back to my original CSV file
Comments
Please sign in to leave a comment.