This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Did you get the answer? I have exactly the same problem. Also localized to Latvia.
Use this custom format: _(* # ##0_);_(* (# ##0);_(* "-"_);_(@_)
Does not work either. And I have the same problem from 2 different computers, both with win 10.