View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vincent Vincent is offline
external usenet poster
 
Posts: 39
Default How to open a csv file without auto converion

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.