How does one set the default locale for each new spreedsheet in Google Sheets?

Question

To change a spreadsheets locale one selects File > Spreadsheet Settings > Locale

There is a problem here in that one must make that change for each new spreadsheet created and not doing so causes some difficulties in that cells need to be changed to the new Locale which isn't always successful.

How does one set the default locale for every new spreedsheet in Google Sheets?

Answer 1

The locale setting is set by the language setting for your account. You can set/change this at: https://myaccount.google.com/language

The timezone is a device setting.

Summarised (and confirmed) from a Google Support question Set default timezone/locale for all current and future Sheets

Answer 2

I had this issue and found a solution. This should also update any new Google Sheets that you create.

Instructions below:

• Open a new Google Sheet
• Click on File
• Click on Spreadsheet Settings
• Click on Display language, This is at the very bottom left of the interface window.
• Click on the Pencil next to the language
• Start typing English into the search bar
• Click on English
• Click on Australia
• Click on Select
• Then Click on Save Settings

Note that it will not update the new sheet in which you made the change but it will for all new sheets created.