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)
Hello, since yesterday my excel keep adding a comma after the last zero no matter the format and i can't find how to solve that.
Can someone please help me with that?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
You may check if this option is checked.
File >Option>Advanced>Uncheck "Automatically insert a decimal point."
You may also need to change the decimal separator from comma to period:
You can check Use system separators to let Excel employ the defaults based on Windows country setting or you can manually override them.
Thank you mate! That solved it. I wonder how the hell did i activated that option
The format is general (but the same problem happens in every other one).
The 20,21/20,22 are meant to be 2021/2022. 50,41 should be 5041,
The 105,97 is meant to be 010597 (no idea why that turned into 105,97)
The 5003,24 is meant to be 500324 and the 510,47 was meant to be 51047. I've tried changing the decimals, the formats and its still fu**ed up.
Could you share us a screenshot of your issue and the number format settings?
If issue only with one file, share us that file without sensitive information.
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.