At work, I have to convert a lot of data from csv files into ActiveRecord objects on a sql server box. For some exasperating reason, ActiveRecord and SQL Server dont like dates that are in 2 digit format.
Fine.
I'll simply go and reformat all the csvs to change their date format from mm/dd/yy to mm/dd/yyyy.
I close the excel document.
Then when I need to reopen it, Excel shows dates in the mm/dd/yyyy format in mm/dd/yy !!!
I wish you could tell excel to stop being helpful in ths regard. It's really really really frustrating.
/END OF RANT
