Forum Discussion
Excel changing numbers, removes the decimal point.
I have a little spreadsheet I use to calculate gas mileage, costs, per tank and annually etc. Excel has decided to eliminate the decimal point in the number field for gas, so I type 12.215 and excel ...
Yes. Under File\Options\Advanced tab, scroll to the Editing section and you will see a checkbox for "Use System Separators." With that box unchecked and the decimal separator being a comma instead of a decimal, and the cell formatted to three decimals and suppress the thousands separator, then I can duplicate your issue. Go to that setting and change your decimal separator back to a decimal (or check the box to use your local machine region settings).
IMHO, the setting changes the behaviour for entire file. I doubt if it affects behaviour when values in one range ignores separator and in another one - not. Both have the same format applied.
- Yes, I know it's an application level setting and affects the entire file. Please note that I said it was probably changed, then the additional two numbers keyed, and then changed back.
I was able to replicate the data he is seeing (correct and incorrect numbers), your opinion notwithstanding, so I do think it is a possibility and the OP should double check the application and machine settings to confirm which one it is using and whether or not they are set correctly.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.
