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
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