19

Is there a way to change settings of decimal separator, thousand separator and date format in Google Sheets?

I would like to have:

  1. dots for decimal,
  2. space for thousand
  3. date in format YYYY-MM-DD.

It is easy to set it up in Microsoft Excel. Can it be done in Google Sheets? I know that Google Sheets has an option to change locale. Is there any locale that has all the settings I want?

1
  • 1
    Complete list of formats here but I don't think any of them gives you space as thousand separator. – user135384 Dec 22 '17 at 22:20
24

You need to go to:

  • File
    → spreadsheet settings
    → General
    → Locale
    → Change for a local that uses dot instead of comma
    (Canada English for example)

spreadsheet settings

select local google sheet

4
  • It does not produce desired results but it is the best we can get. – Przemyslaw Remin Apr 21 '20 at 15:25
  • *Locale. It's not Local. They didn't make a typo. – j riv Jun 23 '20 at 4:50
  • It sucks that this is the right answer. That is, the answer is good but it's annoying that you have to change this per spreadsheet. My computer, browser, Google are all in French but I happen to use period . for decimals... – Luke Sawczak Jan 29 at 15:50
  • Canada (English) sets it to period now, Sweden and Hungary to comma – András Jun 16 at 12:20
5

Try Mongolia for locale and format numbers as:

### ### ### ### ###.00

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.