How to open a csv file without auto converion
Change the extension from .csv to .txt, then the text import wizard will
allow you to specify the format of the relevant columns as text.
--
David Biddulph
"Vincent" wrote in message
...
I have a csv file with a text field enclosed with " ", the content of the
field is numeric but with leading 0s'.
When I Start MS Excel 2003 and then open the file, the field is converted
to
numeric and causes the leading 0 being dropped.
|