Forum Discussion
Solved
Barcodes in Exel
Hi guys i need some major help. I am setting up a POS system for a shop and i'm having issues with the barcode formatting. When first entering the data I have no problems, I reformat the column t...
Ali_111690 On the Data ribbon, you should have a button "Get Data". Click it and select "From Text".
Navigate to the folder with the CSV file. Excel will only highlight TXT files but you can still select the CSV file and press Get Data. The text import wizard opens. In step 1 you select Delimited. In step 2 you set the comma as the delimiter. Step 3 will give you a preview of how the text will be split in columns. Now, make sure that you set the correct data types for each of the columns (General, Text or Date). In your case, you need to set the column with the barcodes as Text. Press finish.
This should import the CSV file in neat columns with the original barcodes as texts, preserving the leading zero's.
We finally figured out that when you export the file from Dear Systems as a csv, the column is in Scientific. On opening it, if we convert it to a standard excel file to work on it/add Data filters etc, we then changed the column to a Number column and adjusted the trailing zeros. Then when we were done, we saved as a csv and didn't open it before re-uploading it. If we did reopen it, it changes the cell back to Scientific. bosinander Riny_van_Eekelen PeterBartholomew1
Thanks for the update.