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

You sure it converted it to a date when the CSV file was created?

Did you use Notepad to verify the output or did you just re-import it to excel?



wnagatani wrote:

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!


--

Dave Peterson