View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wnagatani
 
Posts: n/a
Default XLS to CSV Conversion - #'s convert to Date

When I convert an XLS doc into CSV, I have one field that converts to a date
and I do not want it to. The format of the column is text but it does not
seem to matter. The numbers in the field are alpha-numeric, if they contain
an alpha, it does not convert ot a date, if it is just numeric, it converts
to a date. Here is an example of the values:

1-2006
1-1SR0

Help!