Great. Can we automate changing every single goddamn spreadsheet to not be in US date format? And while we're in there, how about adding a locale for New Zealand?
- visit https://myaccount.google.com/language
- click on (re-choose) English
- click on New Zealand as the 'sub-language'
should set your locale across the board, rather than doing it on a per-sheet basis. If it doesn't work, as a Canadian, I empathize with your troubles and apologize.