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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Simple Methods 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. Add the Desired Number of Decimals Using Format Cells Command
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.
- 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.
We can also avail of the Format Cells by using the keyboard shortcut Ctrl+1.
Read More: How to Insert Dot between Numbers in Excel (3 Ways)
2. Fix the Number of Decimals from Excel Options
By applying this method, decimals will add automatically when typing any number through the dataset.
- 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 decreases 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.
Read More: How to Set Decimal Places in Excel with Formula (5 Effective Ways)
- Converting Time to Decimals in Excel (4 Examples)
- How to Remove Decimals in Excel with Rounding (10 Easy Methods)
- Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)
- How to Convert Hours to Decimal in Excel (3 Easy Methods)
- How to Change Decimals to Percentages in Excel (4 Easy Ways)
3. Add Decimals Using Increase Decimal Command
This is the easiest way to add decimals. We get this command from the Home tab’s Number group.
- 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.
One decimal place is added.
- 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 (3 Effective Ways)
In this article, we showed how to add decimals in Excel with the easiest methods. I hope this will satisfy your needs. Please have a look at our website exceldemy.com and give your suggestions in the comment box.
- How to Convert Decimal Time to Hours and Minutes in Excel
- Stop Excel from Rounding Up Decimals (4 Easy Methods)
- How to Convert Decimal to Time Over 24 Hours in Excel (2 Quick Methods)
- Convert Decimal to Days Hours and Minutes in Excel (3 Methods)
- How to Remove Decimal Places in Excel (5 Easy Methods)
- How to Reduce Decimals in Excel (10 Easy Methods)