How to prevent Excel to use the OS regional settings for date patterns in formulas

--------------------------------------------------
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: Over a Mysterious Island

--

Chapters
00:00 Question
01:53 Accepted answer (Score 31)
09:36 Answer 2 (Score 5)
10:47 Answer 3 (Score 5)
11:45 Answer 4 (Score 1)
12:12 Thank you

--

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

Question links:
[this question]: https://superuser.com/q/730012/68986

--

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

--

Tags
#microsoftexcel2013 #datetime #textformatting #localization

#avk47