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.
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.
Rocky247 Can't really tell until I see what you are trying to import and how.
