I know how to make Google Sheets display dates in ISO 8601 format (YYYY-MM-DD). Now, how do I make them not only display, but edit in the same format?
See the edit line below:
Moreover, if that is linked to a locale in use, which one would have a dollar sign as a default currency sign in addition to having ISO dates?
Best Answer
Partial answer
According to https://en.wikipedia.org/wiki/Date_format_by_country, the following locales use YMD date format:
Afghanistan, Albania, Bangladesh, Cambodia, Canada, China, People's Republic of, Denmark, Germany, Hong Kong, Hungary, Iran, Japan, Kenya, Korea, Latvia, Lithuania, Macau, Mongolia, Myanmar, Namibia, Nepal, Norway, Singapore, Slovenia, South Africa, Sri Lanka, Sweden, Taiwan,Republic of China, United Kingdom, United States of America
Notes
I didn't find a simple table that combines the date format and currency symbol but find the following that could help
Other interesting findings
Spefications / open source projects
Google participates in the below projects, so is very likely that Google Sheets use them
Tools