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...

excel

Excel on Mac

Formulas and Functions

Riny_van_Eekelen
Oct 01, 2021
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.

HShowalt

Copper Contributor

Oct 12, 2022

I am having this exact same issue with a different POS provider. Have tried absolutely everything, but every time I try to upload the csv spreadsheet to my website provider, the product code data column converts automatically back to the scientific code. Anyone figure out any lasting solutions to this issue?Rocky247

Rocky247

Copper Contributor

Oct 12, 2022

Spoiler

Yes, it is easy once you know how.

Save in the csv as a number format and use the sheet. It will be fine. But if you reopen it before uploading it, it WILL revert back everytime. Don’t know the technicalities but it does work.

Yes, it is easy once you know how.Save in the csv as a number format and use the sheet. It will be fine. But if you reopen it before uploading it, it WILL revert back everytime. Don’t know the technicalities but it does work.

Forum Discussion

Barcodes in Exel