34

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?

Improve this question
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

Reset to default
40

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

Improve this answer
4
  • It does not produce desired results but it is the best we can get.
    – Przemyslaw Remin
    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
  • 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...
    – Luke Sawczak
    Jan 29, 2021 at 15:50
  • 1
    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
Improve this answer
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.
    – Tamas Hegedus
    Sep 8, 2021 at 18:52

Your Answer

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

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