Sorry, I forgot to mention that I've already tried renaming from CSV to TXT
without success

"Harry" wrote:

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.