Re:The Microsoft Excel superstars throw down in Vegas
by unsupp0rted on Friday June 14, 2024 @04:29PM
(#40684790)
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.
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.