Automatically Insert a Decimal Point

Stephan Pringle Wednesday, September 10, 2003

Have you noticed that Microsoft Excel will automatically insert a decimal point into ever workbook and worksheet that you open? Someone or yourself has enabled the decimal point feature (default is to divide your number by 100) and you can get rid of it once and for all.

Enable Auto Insert Feature
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. Select the Automatically insert a decimal point box
05. Save your changes by pressing the OK button

Remove Auto Insert Feature
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 your 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.
facebook-profile-picture
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profileMy YouTube channel

Stephan Pringle

Technology Support Specialist at Sipylus
About The Author: Stephan Pringle is an Information Technology Support 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.
facebook-profile-picture
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profileMy YouTube channel

Latest posts by Stephan Pringle (see all)

Related posts:

  1. SSN in Excel Without Hyphens
  2. Enable Automatic Replies in Outlook
  3. Switching Characters in Excel Columns
  4. Automatically Apply WordPress Updates
  5. Show or Hide the Recycle Bin
  6. Unable to Open .SYLK Files
  7. Enable Pause in QuickTime for macOS
  8. Create an EFI Partition for macOS with Ubuntu
  9. Disable Auto-Updates
  10. Locking the Computer
  11. Reinstall Windows Media Player
  12. Enhancing an Auto Attendant
  13. Microsoft Outlook Test Message
  14. Create an EFI Partition
  15. Enable Mopier Mode
  16. Auto Logout Period for Track-It
  17. Windows 7 Service Pack 1
  18. Repair a MYSQL Database
  19. Browser That’s Perfect for Touch
  20. Prevent Your Computer from Turning Off
facebook-profile-picture

Stephan Pringle

About The Author: Stephan Pringle is an Information Technology Support 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.

Related Posts