Forum Discussion
Excel changing numbers, removes the decimal point.
At the same time 12.121 it transformed to 12121
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?
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)
SergeiBaklan Hi fellows-I followed the instructions (sorry for the blurry screenshots it was just easier than retyping it all)
1. I unchecked the box to "Automatically insert a decimal point" under Editing Options.
2. I also validated that the symbols listed in "Use system separators" are a decimal point".", for the Decimal separator; and a comma"," for the Thousands separator.
I dropped the whole spreadsheet. with the changes looks like starting with row 8 the spreadsheet doesn't accept the decimal point in column C "Gals" or Column F.
Arrghhh!
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.
From his screenshot, the fixed decimal is turned on. Maybe when you said to check the setting the OP thought you meant to check the box.
The only thing I've tried that moves the decimal to the right like that is if the decimal and thousands separator are both a period. Although the OP said he checked those previously (back in May) and confirmed they were set to a period and comma, respectively, his recent screenshot really looks like the grouping symbol is a period and not a comma. If I blow it up and look at the digit grouping field, the separator symbol doesn't look like a comma as I don't see any dark pixels below the bottom of the numbers next to it (when I change my setting between a period and comma, the OP's looks more like a period to me).
But, it's hard to say, the screenshot is pretty blurry and my eyes aren't what they used to be.
