• Background
    • Awards
    • Biography
    • Resume
  • Blog
    • Technical Support Blog
    • Cookie Policy
    • Galleries
      • Photo Gallery
      • Video Gallery
    • Glossary
  • Contact
    • Contact
    • Social Networks
  • IT
    • Downloads
      • Windows
    • Equipment
    • Hardware
    • Software
    • Testimonial
    • Information Technology
  • Projects
    • Business Projects
    • PC Projects
      • Hackintosh Laptop Projects
      • Hackintosh Desktop Projects
    • Website Projects
    • More Projects
  • Service Rates
    • Business Rates
    • Residential Rates

Automatically Insert a Decimal Point

Wednesday, September 10, 2003 Articles, Tips Comments Off on Automatically Insert a Decimal Point

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.

https://www.youtube.com/watch?v=PfLj5EMQH0M

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.
  • Bio
  • Latest Posts
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)

  • HP Color LaserJet Pro MFP M477fdw - Friday, April 14, 2023

Related posts:

  1. SSN in Excel Without Hyphens
  2. Enable Automatic Replies in Outlook
  3. Automatically Apply WordPress Updates
  4. Switching Characters in Excel Columns
  5. Show or Hide the Recycle Bin
  6. Enable Pause in QuickTime for macOS
  7. Disable Auto-Updates
  8. Locking the Computer
  9. Enable Mopier Mode
  10. Reinstall Windows Media Player
  11. Create an EFI Partition
  12. Enhancing an Auto Attendant
  13. Microsoft Outlook Test Message
  14. Auto Logout Period for Track-It
  15. Repair a MYSQL Database
  16. Windows 7 Service Pack 1
  17. Browser That’s Perfect for Touch
  18. Change a Local Password on Windows
  19. Program a Receiver and Transmitter
  20. End a Technician’s Track-It Session

Comments are closed.




Copyright © 1990-2023 Stephan Pringle. All rights reserved.

The information contained on this website is for your personal use only.
It may not be reproduced in whole or in part, by any means, for dissemination without our written permission.

Stephan Pringle

Technical Support Specialist

  • Keyword Search

  • Topic Sponsor