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:

Default ThumbnailImporting a PDF File to an Excel File Default ThumbnailSwitching Characters in Excel Columns Default ThumbnailSSN in Excel Without Hyphens Default ThumbnailConverting a PDF File to an Excel File Default ThumbnailCreate an EFI Partition for macOS with Ubuntu Default ThumbnailShow or Hide the Recycle Bin Default ThumbnailUnable to Open .SYLK Files Default ThumbnailBrowser That’s Perfect for Touch Default ThumbnailSave a Microsoft Outlook Email as a PDF File Default ThumbnailPrevent Your Computer from Turning Off Default ThumbnailLocking the Computer Default ThumbnailNetwork Printer on Windows XP Default ThumbnailReinstall Windows Media Player Default ThumbnailCreate an EFI Partition Default ThumbnailCold Reset an MFP HP Printer Default ThumbnailEnable Automatic Replies in Outlook Default ThumbnailAutomatically Apply WordPress Updates Default ThumbnailHide or Unhide an Internal Hard Drive Default ThumbnailHide or Unhide an External Hard Drive Default ThumbnailWeb Hosting Options
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