28

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, 2017 at 22:20

2 Answers 2

35

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. Apr 21, 2020 at 15:25
  • 1
    *Locale. It's not Local. They didn't make a typo.
    – j riv
    Jun 23, 2020 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... Jan 29, 2021 at 15:50
  • Canada (English) sets it to period now, Sweden and Hungary to comma
    – András
    Jun 16, 2021 at 12:20
6

Try Mongolia for locale and format numbers as:

### ### ### ### ###.00
1
  • This is what I use but it messes up minus signs before small negative numbers. It puts all the spaces between the negative sign and the first number. Sep 8, 2021 at 18:52

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.