Forum Discussion
Barcodes in Exel
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.
Riny_van_EekelenI seem to have tried all possible options....but cannot get the column to import properly. Still importing in a formula at 5.06E+12 (for example). Have tried to open an excel file and import the data, even tried to do it in Google sheets. Not sure your option below works..??
Importing a number and displaying as 5.06E+12 is not, of itself, a problem. It is perfectly possible to display the number as a sequence of 13 digits padded with leading zeros by applying a number format
"0000000000000". What is more troubling is that you seem to have imported some codes as text and others as numbers. I am not sure why this is.
- PeterBartholomew1 we've exported the data from our inventory system, and that column shows data like that 5.06E+12. We can then reformat that particular column to show it how we want it, but on resaving as a CSV it reverts to 5.06E+12.
If that means you lose the last 10 digits of the code then there is no way back! Can you introduce a formula to create a text helper column? If so
= TEXT(value, REPT(0,13))will give a text string that should upload correctly.
- PeterBartholomew1 Thanks for that - I was able to create a new column which displayed the data correctly (then I copied the data in the resuting column and repasted it as values only), but on exporting to a csv again to upload back into the system again I am left with the same issue.