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.

View on HN

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!

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.

Reply on news.ycombinator.com