CSV files don't trigger the import wizard and if you use the opentext method
in VBA with a file with a .csv extension, then the setting specified in
Opentext command are ignored. At least in most versions of excel.

--
Regards,
Tom Ogilvy

"Kanan" wrote in message
...
in step 3 of the import wizard, highlight all columns and check the text
box
on the top right. That should fix the problem.
good luck
kk

"ajmister" wrote:

Hi

I am importing a .csv file into excel. One of the columns has
values
like 46120E60, 03235E10 etc. When the .csv file is imported into excel
those
values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13.
Any
suggestions on how to fix that.

Ajmister