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 ...
Actually, I did duplicate it.
With system separators unchecked, I played with the decimal and thousands separators and keyed some numbers (which displayed 13,935,000 when I entered 13.935). Then I went back into the options and checked the system separators box (which I think reverts the setting your machines regional system setting) and that changed it to 13935.000 like what you are seeing).
So, maybe the setting was changed, the data was keyed, and then the setting was changed back?
With system separators unchecked, I played with the decimal and thousands separators and keyed some numbers (which displayed 13,935,000 when I entered 13.935). Then I went back into the options and checked the system separators box (which I think reverts the setting your machines regional system setting) and that changed it to 13935.000 like what you are seeing).
So, maybe the setting was changed, the data was keyed, and then the setting was changed back?