# How to automatically add Decimal Points in Microsoft Excel

## Check How to automatically add Decimal Points in Microsoft Excel

If you type 10.00 in an Excel cell, it will automatically convert to 10 by removing the zeros after the decimal point. While this is a smart move, sometimes you may want all of your numbers to display a certain number of decimal places, even if they are zeros. While Excel doesn’t allow this by default (since it doesn’t just allow zeros after the decimal), you can easily change this by changing the cells’ custom number format.

Applying a number format to a cell doesn’t change the value, only how the value is displayed in the worksheet. The format can play tricks on you, for example, B. The sum of the values ​​seems wrong because Excel displays a limited number of decimal places and their sum is not equal to the actual sum. In the Number group, click the dialog box launcher ( the small slanted arrow in the lower right corner of the group). You can also use the keyboard shortcut Ctrl + 1

## How to Add Decimal Points Automatically in Excel

• Open Microsoft Excel on your computer.
• Click File > Options.
• Go to the Advanced tab.
• Check the Automatically insert a decimal point check box.
• Enter the locations and click the OK button.

## How to automatically insert decimal points in Excel using Group Policy

To automatically insert decimal points in Excel using Group Policy, follow these steps:

• Press Win+R to open the Run dialog.
• Type gpedit.msc and hit the Enter button.
• Go to Excel Options/Advanced in User Settings.
• Double-click the Automatically insert a decimal point setting.
• Choose the Enabled option.
• Click the OK button.
• Restart Microsoft Excel.

### Let’s look at these steps in detail.

• First, you need to open the Local Group Policy Editor. For that, press Win+R to open the Run dialog, type gpedit.msc and press Enter button.
• Next, navigate to the following path:
• User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Advanced
• Find the Automatically insert a decimal point on the right side setting and double-click it.
• Choose the Enabled option and click the OK button

## How to add decimal points automatically in Excel using the Registry

• Search for regedit in the taskbar search box.
• Click on the search result and click the Yes button.
• Navigate to 0 on HKCU.
• Right-click 0 > New > Key and name it Excel.
• Right click Excel > New > Key and set the name as options.
• Right-click Options > New > DWORD (32-bit) Value.
• Name it autodec.
• Double click it and set the value data according to your requirements.
• Click the OK button and restart your computer.

## Final remarks: How to automatically add Decimal Points in Microsoft Excel

Editorial Staffhttps://www.bollyinside.com
The Bollyinside editorial staff is made up of tech experts with more than 10 years of experience Led by Sumit Chauhan. We started in 2014 and now Bollyinside is a leading tech resource, offering everything from product reviews and tech guides to marketing tips. Think of us as your go-to tech encyclopedia!

### .tdb_module_title{display:block;position:relative;margin:0;font-family:var(--td_default_google_font_2,'Roboto',sans-serif);font-size:21px;font-weight:400;line-height:1.2}.tdb_module_title a{transform:translateZ(0);transition:box-shadow 0.2s ease;-webkit-transition:box-shadow 0.2s ease}.tdb_module_title .tdb-module-title-excl{font-family:var(--td_default_google_font_2,'Roboto',sans-serif);color:#fff;background-color:#ff0000;padding:4px 8px 2px;margin-right:8px;font-size:14px;font-weight:500;line-height:1;vertical-align:middle}.tdb_module_title .td-element-style{z-index:-1}.tdb_module_template_387521 .tdc-row .tdb_module_title_0{text-align:left;font-family:var(--general)!important;font-size:22px!important;line-height:1.2!important;font-weight:700!important}.tdb_module_template_387521 .tdc-row .tdb_module_title_0 a{color:var(--dark)}.tdb_module_template_387521 .tdc-row .tdb_module_title_0:hover a{color:var(--accent)}.tdb_module_template_387521 .tdc-row .tdb_module_title_0 .tdb-module-title-excl{display:inline-block}@media (min-width:768px) and (max-width:1018px){.tdb_module_template_387521 .tdc-row .tdb_module_title_0{font-family:var(--general)!important;font-size:18px!important;line-height:1.2!important;font-weight:700!important}}@media (max-width:767px){.tdb_module_template_387521 .tdc-row .tdb_module_title_0{font-family:var(--general)!important;font-size:18px!important;line-height:1.2!important;font-weight:700!important}}Best Telemedicine Software: for your healthcare practice

Telemedicine software has transformed my healthcare visits. It's fantastic for patients and doctors since they can obtain aid quickly. I...

### Best Microlearning Platforms: enhance your knowledge

I love microlearning Platforms in today's fast-paced world. Short, focused teachings that engage me are key. Microlearning platforms are great...

### How To Use Microsoft OneNote (10 simple steps)

Think of a notebook on your computer or tablet that can be changed to fit whatever you want to write...

### Best Homeschool Apps: enhancing your student engagement

As of late, Homeschool Apps has gained a lot of popularity, which means that an increasing number of...

### Best Free HelpDesk Software: improves your customer satisfaction

From what I've seen, HelpDesk software is essential for modern businesses to run easily. It's especially useful for improving customer...

### How to Delete Files From Google Drive on Desktop and Mobile

For all of our important pictures, stories, and drawings, Google Drive is like a big toy box. But sometimes the...