News for hackers. Stuff that matters.
Re:The Microsoft Excel superstars throw down in Vegas by SECProto on Friday June 14, 2024 @03:52PM (#40684390)
If you type those into cells in excel, they all display the same. Excel doesn't store them as dates, it just displays them as such. If you format it as a generic number, the first three lines all show 45306, while the latter three lines show 45294 as the cell value.
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.