# How to Fix Decimal Places in Excel (7 Simple Ways)

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.

## 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.

• 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).
• Then, select the pattern.
• Finally, hit ENTER.

We will have our desired output.

Similar Articles

### 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.

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.

## Related Articles

#### Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

5 Excel Hacks You Never Knew