Thread

Excel now supports multiple values in a single cell

278 points · 196 comments · luispa

gcanyon · 1790387910 · focus · HN ↗
Excel now support lists and arrays as values in a cell, but it still thinks February 29th, 1900 is a thing because 40 year-old backwards compatibility?
This is a strange world we live in.
Backwards compatibility with Lotus 1-2-3: <a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/wrongly-assumes-1900-is-leap-year" rel="nofollow">https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...
1. NetMageSCW · 1790451166 · focus · HN ↗
  You can switch to the 1904 date system to be Mac compatible and avoid the bug as well.
  1. gcanyon · 1790515182 · focus · HN ↗
    Ooh, interesting -- I didn't know what. Obviously it's a curiosity, not a real annoyance unless I'm trying to calculate how many days my great-grandfather lived :-)

Unofficial Hacker News client; not affiliated with Y Combinator.