How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

-------------------------------------------------------------------------------
Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn
-------------------------------------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Dreaming in Puzzles

--

Chapters
00:00 Question
01:04 Accepted answer (Score 32)
01:22 Answer 2 (Score 4)
01:54 Answer 3 (Score 2)
02:31 Answer 4 (Score 2)
03:45 Thank you

--

Full question
https://superuser.com/questions/409896/h...

Question links:
[ISO 8601]: https://secure.wikimedia.org/wikipedia/e...
[image]: https://i.stack.imgur.com/LZaN4.png

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #dateformat

#avk47