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.
Yes, downloading the csv from Dear Systems, opening it to remove all lines apart from one where we know the barcode is right, and saving it again, it will not upload back into the system - the barcode changes to scientific Riny_van_Eekelen
Rocky247 Then I don't know. Sorry.