Forum Discussion

Kasiodeco's avatar
Kasiodeco
Copper Contributor
Dec 07, 2022

Automatic converting decimals to thousands

Hi,   When I'm working in Excel it keeps changing my long decimal number to thousands.  E.g. if I type 1.0835 it writes 10835 instead. Does anyone have a fix for that particular issue?   Kind Re...
Excel
Excel on mobile
Formulas and Functions
office 365
HansVogelaar's avatar
HansVogelaar
MVP

Kasiodeco 

Is this really about Excel on mobile? If so: do you use comma as decimal separator on that device? If that is the case, enter 1,0835

Kasiodeco's avatar
Kasiodeco
Copper Contributor
Dec 07, 2022

HansVogelaar

No, you can disregard the Mobile tag.

I use full stop ¨.¨ as the decimal separator 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 07, 2022

    Kasiodeco 

    Select File > Options.

    Select Advanced.

    In the Editing section, clear the check box 'Automatically insert a decimal point'.

    Click OK.

    • Kasiodeco's avatar
      Kasiodeco
      Copper Contributor
      Dec 07, 2022
      I have tried that as well, it doesn't fix the problem

Resources