Originally posted by jamesbond
[B]I have an excel sheet with date columns in the format yyyy-mm-dd
When I export this file to csv format the date format (with excel or openoffice) has been changed to mm/dd/yyyy
Aside from the fact that mm/dd/yyyy doesn't make any sense to me, is there a way I can prevent excel or openoffice from converting the dates from yyyy-mm-dd to mm/dd/yyyy when I export to csv format?
I need to import the csv file into a mysql database. [/B]
I created a simple two-column, four-row Excel 97 spreadsheet that looked like
The date field I set the format to "yyyy-mm-dd" by right clicking the range, selecting format, selecting custom and entering the format in the field. When I did a save as to CSV, this was the result:
The date format was preserved, so if you're setting the date format of the field, I'm not sure where you're problem lies.