Before you import, change the file extension from .csv to .txt. Then, using
the wizard, you'll be able to specify that the long numbers should be
treated as text.

Excel can only cope with 15 significant figures, so any "number" with more
(like a credit card number) will be truncated one way or another unless you
tell excel to treat it as text.

--
Noel
"Harry" wrote in message
...
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.