6 ms·

Except Excel doesn't recognize ISO timestamps either.

• mulmen 3y ago
  Are you sure? It seems to for me, which is annoying because by recognizing them it changes them to a localized date format which then breaks when sent overseas. If I type "2023-08-22" into a cell in Excel I see "8/22/23" in the cell and "8/22/2023" as the value.
  • ooterness 3y ago
    Definitely broken for me on Excel version 2302 (build 16130.20714) on an En/US locale. None of the ISO8601 formats I've tried are recognized. "2023-08-22", "2023-08-22T01:38:22Z", "20230822T013822Z" are all valid ISO8601, but Excel treats them as unformatted text. Inputs with slashes are instantly recognized as a date. If it works for you, it may be a locale thing. But getting away from that is the whole point of ISO8601.
    • mulmen 3y ago
      I am En/US but on MacOS.