4 ms·

I've yet to find a reliable way to prevent Excel from destroying dates (or seeing dates in other data) though. In this regard I prefer LibreOffice. (Or SQLite,

I've yet to find a reliable way to prevent Excel from destroying dates (or seeing dates in other data) though. In this regard I prefer LibreOffice. (Or SQLite, if I'm the only person working on it.) I might have missed something obvious though so feel free to point it out. Google failed me though.

phonon 8y ago
Use From Text or Get & Transform...you can tell Excel how to Type each column. https://professor-excel.com/import-csv-text-files-excel/ https://professor-excel.com/import-csv-text-files-excel/