4 ms·
In my case, usually the column comes into Excel via copy/paste of a dozen mixed columns, or File-Open on a CSV. The workaround, at least for CSVs, is to do an
by unsupp0rted 2y ago
In my case, usually the column comes into Excel via copy/paste of a dozen mixed columns, or File-Open on a CSV.
The workaround, at least for CSVs, is to do an import via "Get Data" -> "From Text (legacy)" and tag the relevant column as "date". This doesn't always work though.