Opening .csv

G

Greg

Excel 97.

I have a VBA routine that opens a .csv file and processes
some information.

My problem is that excel changes some of the fields
automatically upon opening it. For example, I have a
field that reads "1002.10". Excel thinks that it is a
number and automatically lops off the trailing zero.

Is there anyway to turn off a setting so that excel will
just open the .csv file as text and not try and convert
any fields?

Thanks,

Greg
 
J

Jim Rech

Excel automatically parses CSV files. If you change the file extension to
something else, like TXT, Excel will instead pop up the File Import Wizard
where you can make choices. On the third screen (I think) you can choose
the formatting of each field. You'd pick Text for this one.
 
G

Greg

Thanks Jim.

I was hoping that I could some how automatically turn off
that automatic parsing. Oh well, I will use your
suggestion. Thanks.
 
Top