undefined | Better HN

0 pointsmulmen2y ago0 comments

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.

0 comments

ooterness2y 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.

mulmenOP2y ago

I am En/US but on MacOS.

j / k navigate · click thread line to collapse