News for hackers. Stuff that matters.
Re:Cursed Excel: "1/2"+1=45660 by post-it on Monday April 07, 2025 @01:20PM (#43613782)
I think most people that enter `1/2` in a spreadsheet do indeed mean `January 2nd` and not `0.5`. In the wider world of people using spreadsheets, dates are certainly more common than fractions.
Re:Cursed Excel: "1/2"+1=45660 by lawn on Monday April 07, 2025 @01:39PM (#43613965)
In Sweden we don't use that numbering scheme and instead use Day/Month Year (which makes more sense as it goes from smaller to larger).
Re:Cursed Excel: "1/2"+1=45660 by brassattax on Monday April 07, 2025 @01:48PM (#43614046)
It would be interesting to know if your Excel correctly interprets 1/2 as 1st February based on your international settings.
Re:Cursed Excel: "1/2"+1=45660 by dreghgh on Monday April 07, 2025 @03:14PM (#43614834)
Spoiler: it does.
Re:Cursed Excel: "1/2"+1=45660 by niij on Tuesday April 08, 2025 @12:06AM (#43618257)
I think it's just what you're used to. If counting from smallest to largest was inherently better, then a dozen would look like 21, not 12. Little vs Big Endian, I suppose.
Re:Cursed Excel: "1/2"+1=45660 by lawn on Tuesday April 08, 2025 @01:14AM (#43618533)
The issue is when you do Month/Day/Year, then you lose consistency. Both Year/Month/Day or Day/Month/Year are more logical.
Re:Cursed Excel: "1/2"+1=45660 by thesuitonym on Monday April 07, 2025 @05:15PM (#43616031)
You're right about that, but maybe it should just treat '1/2' as '1/2' and only convert it if it makes sense for the current operation. If I type 1/2 and I want the date, then I want 1/2, not Feb 1, or Jan 2, or 01/02/2025, or 2025-02-01, unless again, I have explicitly specified that this cell is a date, and this is the format I want it in.