Hacker News Reader

I suspect you have tried this, but if not,

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

I've also found visiting https://calendar.google.com/calendar/b/1/r/settings

and setting date format there useful. Not sure if it's a universal setting like the previous, though.

Wow, that seems to have got closer, thank you. Spreadsheets are now created with Australian locale, although they have now lost their default timezone completely.

I'm interested whether this change will affect other Google products, in particular whether it messes up the operation of Google Assistant on my phone (possibly that can be overridden).

Cheers!

ISO 8601 needs to be default everywhere.

Similarly, a few weather apps incorrectly show the temperature in Fahrenheit for European users. It's very annoying.