Dec 28 2019 05:59 AM
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.
Dec 28 2019 07:53 AM
Hi,
Please go to Excel Options >> Advanced, and make sure that this checkbox isn't checked:
Hope that helps
Dec 28 2019 02:47 PM
@Haytham Amairah thank you very much. it worked.
Mar 14 2023 07:17 AM
@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.....