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?


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

| improve this answer | |
  • ah yes! that's the one! It was already set to English UK but I needed to just set it again - a little popup at the bottom, possibly easily missed, said 'not all apps are set to UK, would you like to change them all?' – atreeon May 6 at 13:00
  • If this is the official solution from google it's a huge design flaw. I'm Argentinian, I use the d/m/y format, but I've used software in english from the past 35 years since I got my first Commodore 64. The interface language is not the locale. If I want to use the correct locale for date format, I have to choose Spanish for the user interface, which is not what I want. If I want to use the english language for the locale, I'm stuck to whatever date format is used in what google regards as english speaking countries. – Petruza Oct 2 at 12:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.