csv with 12 number column & opens as scientific formula

[Bluecap]

I have tried conerting the column to number format - doesn't work
have tried an apostrophe in front of numbers - didn't work

have not tried hammer, but soon . . .

 

[Gloria Thrurk]

Try this - I discovered it only today.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp


I was having another kind of pb. but solved it my manually modifying my
schema.ini.
Make a safecopy of your schema.ini before modifying it.

You can specify all sorts of parameters for your data files in schema.ini
.....
Including data types.

HTH

Gloria.