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 ...
I don't have an answer on what is happening, that's why I asked to clarify every item I asked. Otherwise we could only make the guesses what is actually happens.
Also looks like the issues start in line 8, it's ok in the previous lines, Column C and Column F, should show the decimal for number of gallons (C-10, 11, 12 point something; F show the dollar amount per gallon 1.859, 1.999, whatever)
Great, thanks for sharing
- Glad to hear you got it working.
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!
- 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). - No, I mean the windows regional settings (under control panel). If you refer to Sergei's post on 5/30/20 9:34 AM, Item #1, you will see an example screenshot.
You did follow up to Sergei's post w/ a screenshot, but it's too small to read as the screenshot was of the entire screen. JMB17 I think this is what you wanted. Thanks for the help!
- Can you include a clean picture using the windows snipping tool of the decimal and thousands separator under the windows regional settings?
