|
|
|
Support for the Blue Alligator applications
You are not logged in.
Pages: 1
Topic closed
Example
In the bar code column in the product upload csv i copy and paste a 13 EAN number 5060527610033, i upload but when i down load the file the number is displayed as 5.06e+12 and when i click on that cell it shows me the number now as 5060520000000. It is not doing it to every number and some are kept in the correct format so the barcode can scan other the last 7 numbers are changing to zero.
Offline
When opening CSV files in spreadsheet applications such as Excel, barcode values are viewed as long numbers and are subsequently reformatted by the application (as CSV files do not retain any formatting rules).
In order to get around this, you would be best saving the master copy of the spreadsheet that you work on in one of the Excel formats rather than as a CSV file.
This means that the spreadsheet will keep any column formatting that you've set (such as formatting the barcode column as text).
When you want to upload a copy of the spreadsheet to your cloud account, save/export it as a CSV file and upload that, but continue working with the master copy rather than re-loading the CSV file back into Excel.
Offline
Topic closed
Pages: 1
| Apple, the Apple logo, iPod, iPod touch, iPad and iTunes are trademarks of Apple Inc., registered in the U.S. and other countries. iPhone is a trademark of Apple Inc. App Store is a service mark of Apple Inc. |