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.

How to Fix Decimal Places in Excel


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.

How to Fix Decimal Places in Excel

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

How to Fix Decimal Places in Excel

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.

How to Fix Decimal Places in Excel

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.

How to Fix Decimal Places in Excel

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.

How to Fix Decimal Places in Excel

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


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.

How to Fix Decimal Places in Excel

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

How to Fix Decimal Places in Excel

  • Hit ENTER.

  • AutoFill the remaining cells.

How to Fix Decimal Places in Excel

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.

How to Fix Decimal Places in Excel

  • 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

How to Fix Decimal Places in Excel

  • Press ENTER.

  • AutoFill to finish the process.

How to Fix Decimal Places in Excel

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

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

Leave a reply

ExcelDemy
Logo