Problem with thousands separator

Question

The problem is that instead of grouping by thousands the excel groups the numbers by hundreds.

Respectively, the input is 100000,  the expected result is 100 000, but the outcome at the moment is 10 00 00.

I have combed all the settings and I can not find the answer.

The Microsoft has been localized to a country named Latvia, although I tried setting it to different locales such as English (US), but without results.

I added an image of how it looks in the computer screen.

Answer 1

Click on custom and use the below setting from the "Format Cells" dialog box:

#,##0

Answer 2

Thank you for your answer, however we want the decimal separator to be a space not a comma.

Answer 3

Hi, right click on the mouse, format cells, custom, there enter this format

##0

Answer 4

I really appreciate your comment, but I have already tried that, and you can see the result in the pic => it indeed prints out the space, however it still groups by two numbers not three.

Answer 5

• Can you please upload your excel file in OneDive and share with us so that we can test?
• If it is OK from our end then I think it would be a problem with your OS.