News for hackers. Stuff that matters.

A comment on Cursed Excel: "1/2"+1=45660. Parent comment

Re:Cursed Excel: "1/2"+1=45660 by recursive on Monday April 07, 2025 @04:07PM (#43615401)
No, but I think it's a lot. I'd bet that the vast majority of those round-trip through string serialization, requiring no further user action based on my recommendation.
[ Parent | on HN ]
Re:Cursed Excel: "1/2"+1=45660 by dreghgh on Monday April 07, 2025 @04:26PM (#43615601)
Disagree, the most common way for an experienced user to type a date into Excel is as a partial date if it is this year, eg 4-Apr, which is instantly converted to 04/04/2025 or whatever.

The vast majority of dates I personally type into Excel would be in this form.

[ Parent | on HN ]
Re:Cursed Excel: "1/2"+1=45660 by recursive on Monday April 07, 2025 @05:33PM (#43616189)
Format the column as date. Or turn on the global option for loose type insanity.
[ Parent | on HN ]
Re:Cursed Excel: "1/2"+1=45660 by dreghgh on Tuesday April 08, 2025 @05:49PM (#43626811)
In this thread: people who don't know how to use Excel tell people who do know, how to use it.
[ Parent | on HN ]