Disable auto insert of decimal point in excel 2010.
When typing in excel, the number typed on the worksheet automatically changed to decimal point.
This could happen, if the auto insert of decimal point is enabled.
To disable follow settings below:
Go to the ribbon, click on File.
Select "options".
On the excel options window, click on 'Advance'.
Uncheck "Automatically insert a decimal point".
See image below:
Cheers!! Hope it helps...
When typing in excel, the number typed on the worksheet automatically changed to decimal point.
This could happen, if the auto insert of decimal point is enabled.
To disable follow settings below:
Go to the ribbon, click on File.
Select "options".
On the excel options window, click on 'Advance'.
Uncheck "Automatically insert a decimal point".
See image below:
Cheers!! Hope it helps...
Comments
Post a Comment