2 ms·

Actually Excel finally added a "stop &$*@ing up my data" option recently: https://mashable.com/article/microsoft-excel-disable-setting-auto-conversion-data-into

Actually Excel finally added a "stop &$*@ing up my data" option recently: https://mashable.com/article/microsoft-excel-disable-setting-auto-conversion-data-into-dates https://mashable.com/article/microsoft-excel-disable-setting...

otherme123 3y ago
That helps, no doubt. But last week one of my coworkers touched a Csv with Excel, and all dates went from ISO8601 to MDY. We are based in Europe (i.e. we use DMY at minimum). In my experience, a Csv touched by Excel is not trustable for further analysis.