35

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

2 Answers 2

40

You need to go to:

  • File
    → Settings
    → General
    → Locale
    → Change for a locale that uses a period as decimal separator instead of a comma
    (Canada English for example)

select local google sheet

4
  • It does not produce desired results but it is the best we can get. Commented Apr 21, 2020 at 15:25
  • 1
    *Locale. It's not Local. They didn't make a typo.
    – j riv
    Commented Jun 23, 2020 at 4:50
  • 1
    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... Commented Jan 29, 2021 at 15:50
  • 1
    Canada (English) sets it to period now, Sweden and Hungary to comma
    – András
    Commented 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. Commented Sep 8, 2021 at 18:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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