Forum Discussion
MarkMarkwj
May 18, 2020Copper Contributor
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 ...
JMB17
Dec 02, 2020Bronze Contributor
Your last screenshot of the windows settings kinda looks like the thousands separator is a period and not a comma (which would definitely cause the problem you are having), but it's really hard to tell.
It's the only thing I can think of that would cause your issue. When I open your workbook, I can input the numbers just fine. So, my thought is that it is an application or windows setting pertaining to your number formatting (assuming you're working on the same machine that was used to input the data).
It's the only thing I can think of that would cause your issue. When I open your workbook, I can input the numbers just fine. So, my thought is that it is an application or windows setting pertaining to your number formatting (assuming you're working on the same machine that was used to input the data).
MarkMarkwj
Dec 04, 2020Copper Contributor
JMB17 Duh...I had checked the regional settings before (as suggested) but maybe I didn't reset them -reset all the settings and spreadsheet appears to be working as before. Yea! Thanks to you and Sergei for all the patience and help!
- SergeiBaklanDec 04, 2020MVP
Great, thanks for sharing
- JMB17Dec 04, 2020Bronze ContributorGlad to hear you got it working.