Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel auto divide input numbers by 100

Copper Contributor

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.

3 Replies

@Ian9393

 

Hi,

 

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

Automatically insert a decimal point.png

 

Hope that helps

@Haytham Amairah thank you very much. it worked. 

@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..... :\