Hi folks,
I have been tormented for some time by Excel's habit of exporting dates
to CSV files as mm/dd/yyyy format even if the dates are formatted
dd/mm/yyyy in the display. What's worse, if there are dates that are of
ambiguous (6/6/2011) and unambiguous (16/6/2011) format in the same
column, Excel reformats the unambiguous dates and leaves the ambiguous
ones as they were! Yesterday I discovered that if the dates are in
international format (2011-6-6) Excel seems to export them as
dd/mm/yyyy, and all correctly. As I suspect that there are a lot of R
users who suffer from this, I thought I would pass on the info.
Jim
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
