You'd think after nearly 40 yrs in development, Excel wouldn't continue to be such a menace.
Interesting one today, as I downloaded some point data from silo, with the years as yyyy-mm-dd. I briefly opened it in excel to have a quick geeze, and unbeknownst to me Excel changed the dates from 1900 onwards to dd/mm/yyyy, but left the pre-1900 dates as yyyy-mm-dd.
The most baffling part is that this persisted when I then loaded the .csv into R. HOW does that happen? Data science truly brings me so much joy.






