H
Harry
I'm trying to import data from a CSV file, where one of the columns contains
both text and numbers. This column is being imported as a "General" column.
The numbers in the CSV file are like this "6123011162730412"
After the data import, they are shown in Excel as "6.12E+15" or
6123010000000000
Any thoughts on how can this can be resolved would be much appreciated?
Many thanks in advance.
both text and numbers. This column is being imported as a "General" column.
The numbers in the CSV file are like this "6123011162730412"
After the data import, they are shown in Excel as "6.12E+15" or
6123010000000000
Any thoughts on how can this can be resolved would be much appreciated?
Many thanks in advance.