Have you noticed that Microsoft Excel will automatically insert a decimal point into ever workbook and worksheet that you open? Someone or yourself has enable the decimal point feature (default is to divide your number by 100) and you can get rid of it once and for all.
01. Reopen Microsoft Excel
02. Bring up the window for Excel Options with ALT + F + T
03. Select the Advanced option in the left column
04. Unselect the Automatically insert a decimal point box
05. Save you changes by pressing the OK button
You can also leave the box selected and change the number to zero.
The following two tabs change content below.
Stephan Pringle
Chief Executive Officer at Sipylus
About The Author: Stephan Pringle is an Information Technology Specialist. He covers hardware and software and provides tips for you to troubleshoot and repair issues on your own. In his spare time, he writes articles about the State of New York on his Hackintosh and HackBook and that has helped him to become the top contributor of the New York City section of Yahoo! Answers.
Latest posts by Stephan Pringle (see all)
- Administrator Command Prompt - Tuesday, November 5, 2019
