How To Insert Decimal Points Automatically In Excel 2010 Article

X-Men For Dummies is here and we're hosting the ultimate holiday giveaway to celebrate! Enter now for your chance to win. Dummies AI Browse Book & Article Categories

Book & Article Categories

closeTechnologyAcademics & The ArtsHome, Auto, & HobbiesBody, Mind, & SpiritBusiness, Careers, & MoneyCollections

Collections

Explore all collectionscloseBYOB (Be Your Own Boss)Be a Rad DadCareer ShiftingContemplating the CosmosFor Those Seeking Peace of MindFor the Aspiring AficionadoFor the Budding Cannabis EnthusiastFor the College BoundFor the Exam-Season CrammerFor the Game Day PrepperCustom Solutions

• Book & Article Categories
• Collections
• Custom Solutions
• Dummies AI

• Main Menu

• Book & Article Categories

• Technology
• Academics & The Arts
• Home, Auto, & Hobbies
• Body, Mind, & Spirit
• Business, Careers, & Money
• Dummies AI

• Main Menu

• Book & Article Categories

• Technology
• Academics & The Arts
• Home, Auto, & Hobbies
• Body, Mind, & Spirit
• Business, Careers, & Money
• Dummies AI

• Main Menu

• Collections

  Explore all collections

• BYOB (Be Your Own Boss)
• Be a Rad Dad
• Career Shifting
• Contemplating the Cosmos
• For Those Seeking Peace of Mind
• For the Aspiring Aficionado
• For the Budding Cannabis Enthusiast
• For the College Bound
• For the Exam-Season Crammer
• For the Game Day Prepper
• Dummies AI

HomeTechnology ArticlesSoftware ArticlesMicrosoft Products ArticlesExcel ArticlesHow to Insert Decimal Points Automatically in Excel 2010ByGreg Harvey Updated2016-03-27 13:57:20From the bookExcel 2010 For DummiesShare

• 
• 
• 
• 
• 

Download E-BookExcel 2010 For Dummies Explore Book Microsoft 365 Excel For Dummies Explore BookBuy NowBuy on AmazonBuy on WileySubscribe on PerlegoDownload E-BookExcel 2010 For DummiesExplore Book Microsoft 365 Excel For DummiesExplore BookBuy NowBuy on AmazonBuy on WileySubscribe on Perlego

If you need to enter a bunch of numbers in an Excel 2010 worksheet that use the same number of decimal places, you can turn on Excel’s Fixed Decimal setting and have the program enter the decimals for you. All you do is type the digits and complete the entry in the cell.

For example, to enter the numeric value 100.99 in a cell after fixing the decimal point to two places, type the digits 10099 without typing the period for a decimal point. When you complete the cell entry, Excel automatically inserts a decimal point two places from the right in the number you typed, leaving 100.99 in the cell.

To fix the number of decimal places in a numeric entry, follow these steps:

Click the File tab and then click Excel Options.

The Excel Options dialog box appears.

Click the Advanced tab.

The Advanced options appear in the right pane.

Select the Automatically Insert a Decimal Point check box in the Editing Options section.

By default, Excel fixes the decimal place two places to the left of the last number you type. To change the default Places setting, go to Step 4; otherwise move to Step 5.

(Optional) Type a new number in the Places text box or use the spinner buttons to change the value.

For example, you could change the Places setting to 3 to enter numbers with the following decimal placement: 00.000.

Click OK.

Excel displays the Fixed Decimal status indicator on the Status bar to let you know that the Fixed Decimal feature is now active.

About This Article

This article is from the book: 

Excel 2010 For Dummies

About the book author:

Greg Harvey is a language scholar who has traced the roots of Tolkien’s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon.

This article can be found in the category: 

ExcelGet a Subscription