View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.