Naimul Hasan Arif
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.
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.
