Forum Discussion

Ian9393's avatar
Ian9393
Copper Contributor
Dec 28, 2019

Excel auto divide input numbers by 100

May I know why excel worksheet divide all input numbers by 100?

for example, I typed in 100 and got 1 in the cell; typed 1000 and cell shows 10.

thank you.

Excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 28, 2019

    Ian9393

     

    Hi,

     

    Please go to Excel Options >> Advanced, and make sure that this checkbox isn't checked:

     

    Hope that helps

    • JWAFrance's avatar
      JWAFrance
      Copper Contributor
      Mar 14, 2023

      Haytham Amairah  Excel 16.70.  
      Thank you for the solution but the toggle box is seriously wrongly labelled! : It is nothing to do with the insertion of a decimal point. It is having the input numbers in both new and existing workbooks divided by 100.    
      That should be illegal - what a waste of my time..... 😕