# How to add decimals in Excel

You can watch a video tutorial here.

Excel is frequently used for calculations and has many functions to help with basic mathematical operations. When performing calculations, the resulting number may have many decimal places that are not displayed. Also, when you are typing in data, by default decimal places are not displayed. You may want to add decimal places to numbers that are shown as whole numbers or you may want the number you have typed to have decimal places. Here we will look at both options.

## Option 1 – Use the **Increase Decimal** toolbar button

### Step 1 – Select the data

- Select the column of numbers to be formatted in either of the following ways:
- Click on the first cell of the column, hold down the left-click button on the mouse, and drag to the end of the column
- Select the first cell of the column, hold down the
**Shift**key and press the down arrow key till the last cell of the column is selected

### Step 2 – Increase the decimal places

- Go to
**Home > Number** - Click the
**Increase Decimal**button to increase the number of decimal places - Each click will increase the decimal places by one number so to add 2 decimal places you need to click twice

## Option 2 – Format the cells to display decimal places when typing

### Step 1 – Select the range

- Select the range where you want decimal places to be added to the numbers in either of the following ways:
- Click on the first cell of the column, hold down the left-click button on the mouse, and drag to the end of the column
- Select the first cell of the column, hold down the
**Shift**key and press the down arrow key till the last cell of the column is selected

### Step 2 – Open the **Format Cells **window

- Right-click and select
**Format Cells**from the context menu

OR

Go to **Home > Number ** and click on the arrow to expand the menu

OR

Go to **Home > Cells > Format > Format Cells**

OR

Press **Ctrl+1**

### Step 3 – Define the format

- On the
**Number**tab, select the**Number**category - Specify ‘2’ as the number of decimal places
- Click
**OK**

### Step 4 – Type in the numbers

- In the column, start typing the numbers
- The numbers will have 2 decimal places

*Note 1: For numbers with decimal values you will have to type the decimal point, but decimals will be added to whole numbers as well*

*Note 2: This method can be used to add decimal places to an existing column of numbers as well*