How to Add Decimals in Excel: 4 Easy Ways

Method 1 – Using Format Cells Dialog Box

  1. Select the cells where you want to add decimals.
  2. Go to Home tab > Number group > Format Cells Dialog Box Launcher.
    The Format Cells dialog box will appear.
  3. In the Format Cells dialog box:
    • Choose Accounting/Currency/Percentage/Scientific from Category based on your data type.
    • Put the number in the Decimal places box and click OK.

    Add the Desired Number of Decimals Using ‘Format Cells’ Command

The number in the Decimal places box shows the number of digits after the decimal point in the selected cells. Look at the dataset.

Note: You can also use the shortcut Ctrl+1.


Method 2 – Fixing the Number of Decimals from Excel Options

  1. Click the File tab > Options.
    Fix the Number of Decimals from Excel OptionsThe Excel Options window will appear.
  2. In the Excel Options window:
    • Select Advanced > Editing options > Automatically insert a decimal point.
    • Under this option, you get the Places You can increase or decrease the decimal places from this box. Set the desired decimal places.
    • Finally, press OK.

    Fix the Number of Decimals from Excel Options

Insert any number; 2 decimal places will be added to the number.


Method 3 – Using Increase Decimal Command

  1. Select the cells where you want to add decimals.
  2. Go to the Home tab > Number group.
  3. Click the Increase Decimal button once to add 1 decimal, twice 2 add 2 decimals, and so on.
    Using Increase Decimal Command

The required number of decimal points will be added to the selected cells.

After using Increase decimal command

 


Method 4 – Inserting Decimal Using Custom Format

  1. Select the cells to add decimals.
  2. Press Ctrl + 1 to open the Format Cells dialog box.
  3. Select  Number tab > Category > Custom.
  4. Insert the target custom format in the Type box.
    I entered $#.000 for accounting format and three decimal places here.
  5. Click OK.
    Custom format decimal points

The decimal points will be added to the selected cells.

 Result of custom formatting


How to Edit Decimal Points in Excel?

  1. Select a cell.
  2. Insert the formula: =ROUND(E4,2)
    You can replace E4 with the cell for which you want to edit decimals.
  3. Press Enter.

As a result, you get the rounded decimals:

Rounding up decimals


Download Practice Workbook


Frequently Asked Question

What if I want to add decimal points to percentages?

If you want to add decimal points to percentages, you can format the cells as percentages with the desired number of decimal places. Alternatively, you can multiply the percentage by 100 to convert it to a decimal and then perform calculations as needed.

How can I round a number down to the nearest whole number in Excel?

To round a number down to the nearest whole number, you can use the FLOOR function. For example, if your number is in cell A1, you can use the formula =FLOOR(A1, 1) to round it down to the nearest integer

How do I display numbers in thousands or millions with decimal points?

A12: To display numbers in thousands or millions with decimal points, format the cells using a custom number format. For example, to display as thousands with two decimal places, use the format #,##0.00,”K” for millions, use #,##0.00,,”M”.


Related Articles


<< Go Back to Number Format | Learn Excel

 

 

 

 

 

 

 

 

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo