Forum Discussion
Excel changing numbers, removes the decimal point.
JMB17 Thanks all I had tried this previously, doesn't seem to work for me. I also just tried to make a brand new spreadsheet and the same error appears??? closed and reopened the spreadsheet and made the suggested changes, retyped the decimal point all to no avail still have the same issue.
You also checked Windows number formats under region/language settings in control panel?
With both the decimal separator and group separator set to a period (instead of group separator being a comma), I get exactly what you are seeing (new inputs have the decimal moved 3 places without affecting the existing numbers).
I downloaded your file, keyed another entry, and get exactly what you are seeing (keyed as 12.215 and 1.719 and the decimal moved 3 places after hitting enter).
If this is not your issue, I'm afraid I'm at a loss for any further suggestions.
