excel changes a string in a csv file to a date format! how to get around this?

  • Thread starter Thread starter hilz
  • Start date Start date
H

hilz

hi experts...
i have a csv file with a one field as follows:
........ ,"2300-1-6", ...............
this is not a date. it is a string that i want to appear just like that.
but in excel, it imports it as a date and changes it to 1/6/2300
i tried to change the cell format from date to general (or text), but this
makes it appear as 146104.

i tired to rename the .csv file to .txt and play with the import options,
but nothing worked.
can someone please help!
thanks
hilz
 
Never mind.
i found it.
When the file is changed to txt file, the import options can handle it.
i just did not know how to do it before, but after playing with it a little,
it worked!

thanks
hilz
 
Back
Top