We all love to see decorated beautiful things. In order to decorate our data, sometimes we face the necessity to **fix decimal places in Excel**. Here, I will try to discuss 7 simple ways to do so.

For more simplification, we are going to use a **Dataset **containing **Company **and **Market Value in Billions **columns.

**Table of Contents**hide

## Download Practice Workbook

## 7 Simple Ways to Fix Decimal Places in Excel

### 1. Using Advanced Feature to Fix Decimal Places

We can adopt the **Advanced Feature **from the **File **tab to **fix decimal places in Excel**.

**Steps:**

- Go to
**File —> Options**.

- Then, choose
**Advanced**. - You have to check the
**Automatically insert a decimal point**box and set the**Places (i.e. 2)**. - Press
**ENTER**.

Then, the input value will automatically convert to the fixed decimal places. As I have given the command to take **two places **after the decimal, the rest of the values will be ignored.

**Read More: How to Insert Dot between Numbers in Excel (3 Ways)**

### 2. Applying Increase Decimal or Decrease Decimal Commands from Ribbon

We can also apply **Increase Decimal **and **Decrease Decimal **commands from the ribbon to perform our desired task.

**Steps:**

- First of all, select the values.
- Go to the
**Home**tab and select the**Decrease Decimal**

The selected values will be decreased to the decimal places according to the user’s choice.

- You can also click on the
**Increase Decimal**command to increase the decimal places.

Thus, we can fix decimal places.

**Read More: How to Set Decimal Places in Excel with Formula (5 Effective Ways)**

### 3. Utilizing Built-in Number Format from Ribbon

There are some** built-in **number formats in the **ribbon **to adjust the decimal places.

**Steps:**

- Firstly, select the values.
- Go to the
**Home**tab and click on the**Number Format** - Then, choose
**More Number Formats**.

A **Format Cells **box will appear.

- From the
**Category**, choose your data type(**e. Currency**). - Fix your decimal places.
- Then, select the pattern.
- Finally, hit
**ENTER**.

We will have our desired output.

**Read More:** **How to Remove Decimal Places in Excel (5 Easy Methods)**

**Similar Articles**

**How to Convert Decimal to Days Hours and Minutes in Excel (3 Methods)****Convert Hours to Decimal in Excel (3 Easy Methods)****How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)**

### 4. Using ROUND Function to Fix Decimal Places

**The ROUND Function **can also be used to perform our purpose.

**Steps:**

- Select a cell (
**e. D5**). - Input the following formula:

`=ROUND(C5,2)`

Where,

**C5 **= The number we want to round down

**2 **= The number of digits to which we want in the decimal positions

- Press
**ENTER**.

- Now, use
**Fill Handle**to**AutoFill**the rests.

**Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)**

### 5. Applying ROUNDUP Function to Fix Decimal Places

**The ROUNDUP Function **is an amazing function to **fix decimal places**.

**Steps:**

- Select a cell (
**e. D5**). - Input the following formula:

`=ROUNDUP(C5,1)`

Where,

**C5 **= The number we want to round down

**1 **= The number of digits to which we want in the decimal positions

- Hit
**ENTER**.

**AutoFill**the remaining cells.

**Read More: How to Remove Decimals Without Rounding in Excel (4 Suitable Ways)**

### 6. Fix Decimal Places Using ROUNDDOWN Function

There is another option named **the ****ROUNDDOWN Function **to **fix decimal places**.

**Steps:**

- Pick a cell (
**e. D5**). - Write the following formula in that cell:

`=ROUNDDOWN(C5,0)`

Where,

**C5 **= The number we want to round down

**0 **= The number of digits to which we want in the decimal positions

- Next, press
**ENTER**.

- Finally,
**AutoFill**the rests.

**Read More: Excel 2 Decimal Places without Rounding (4 Efficient Ways)**

### 7. Application of TRUNC Function to Fix Decimal Places

**The TRUNC Function **can also **fix decimal places**.

**Steps:**

- First of all, select a cell. I selected cell
**D5**. - Next, input the following formula in the
**D5**cell:

`=TRUNC(C5,1)`

** **Where,

**C5 **= The number we want to round down

**1 **= The number of digits to which we want in the decimal positions

- Press
**ENTER**.

**AutoFill**to finish the process.

**Read More: How to Reduce Decimals in Excel (10 Easy Methods)**

## Practice Section

You can practice here for more expertise.

## Conclusion

I have mentioned 7 simple ways to **fix decimal places in Excel**. Hopefully, it will be helpful for Excel users. For any more questions, comment below.