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
|