# How to Add Decimals in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Decimals are common in use while dealing with currency, accounting, measurement, etc. data. In this article, we will discuss how to add decimals in Excel.

Here, we will show 3 methods to add decimals in Excel. These methods will automatically add decimals in the whole dataset, or decimals in the selective cells only.

## 1. Adding the Desired Number of Decimals Using Format Cells Command in Excel

In this section, we will add decimals using the Format Cells option. We have a dataset of some employees with their salaries and department names. Now, we will add decimals with the salary values.

Steps:

• First, select the cells of the SalaryÂ column.
• From the Home tab, go to the Number group.Â Click on the right-down arrow as in the following screenshot.

• The Format Cells window appears.
• Those values are now formatted as accounting. Put the desired number in the Decimal placesÂ box.
• Finally, press OK.

The number in the Decimal places box means how many digits after the decimal point will be shown in the selected cells.

• Now, look at the dataset.

Two decimal places are added to the data.

Note:

We can also avail of the Format Cells by using the keyboard shortcut Ctrl+1.

## 2. Fixing the Number of Decimals from Excel Options

By applying this method, decimals will be added automatically when typing any number through the dataset.

Steps:

• Click on the File tab of the worksheet.
• Press the Options from the menu.

• Excel Options window will appear.
• From the left side select the AdvancedÂ option.
• From the right side menu, go to Editing options.
• Now, mark the Automatically insert a decimal point.
• Under this option, we get the PlacesÂ box. We can increase or decrease the decimal places from this box. Set the desired decimal places.
• Finally, press OK.

• Now, when we input the salaries in the Salary column, 2 digits after the decimal point will be added to the salary values.

## 3. Using Increase Decimal Command to Add Decimals in Excel

This is the easiest way to add decimals. We get this command from the Home tabâ€™s Number group.

Steps:

• Select any of the cells of the Salary column.
• Then, go to the Number group of the HomeÂ tab.
• We can see two options indicating decimals.
• We click on the Increase DecimalÂ option.

• Look at the Cell D4Â of the dataset.

• Again, click on the Increase DecimalÂ option.

Another decimal point was added. In this way, add decimal places from the rest of the cells.

• Select the rest of the cells and click on the Increase DecimalÂ as mentioned previously.

Read More: How to Change Decimal Places in Excel

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF