Forum Discussion

MarkMarkwj's avatar
MarkMarkwj
Copper Contributor
May 18, 2020

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 ...
excel
JMB17's avatar
JMB17
Bronze Contributor
May 22, 2020
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).
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 22, 2020

JMB17 

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.

  • JMB17's avatar
    JMB17
    Bronze Contributor
    May 22, 2020
    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.
    • MarkMarkwj's avatar
      MarkMarkwj
      Copper Contributor
      May 26, 2020

      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.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 27, 2020

        MarkMarkwj 

        Mark, how exactly "same issue" looks?

        - you open new workbook

        - type numbers like 12.345 into the cells from top to down

        - in rows from 1 to 12 (or so) Excel shows as it is entered, i.e. 12.345

        - in next rows starting from #13 Excel shows 12345 ignoring decimal point

         

        Or that's another behaviour?

Resources