You May have loads of numbers data with those weird-looking decimals like 123.901, 182.11 etc. Therefore, to reduce those after decimal numbers we have a 2 step solution for you.

Round a number down is basically using the ROUNDDOWN Function in excel. 

Previously: How to add ‘Last Updated’ or similar before the date in excel?

In the following, this is what happens:


Here’s an example where values as well as digits are given.


The first step is to input the formula.

The formula for the same is as follows:


The following formula has two requirements.

First is the number and the second is the number digits.

To this point, there would be a question in your mind bugging you. What does digit signify in this situation?

Basically, digits reduce the last digit. 

To understand the same, let’s take a look:


Select the value in the formula, in the above it is cell C3.


Then select the digit, cell D3.

And press enter.


Now as you can observe in the image above, the result for the first value and digit is the same as the value because the number digit is 3. 

And as there are 3 digits only after the decimal so there are no changes made.


Then come the second value and digit where the digit number is 2, now as you can observe in the result, the value was reduced to 2 digits after the decimal.

The same goes on. 

If the digit is in negative value then, it’s obvious that the decimals will be removed but as per the digit given in the negative sign, its last digit/s will turn into zero.

For example, 2345.567 with -1 digit becomes 2340.

As its -1 so the last digit before decimal became 0.

The same goes with the other two:

4321.321 with a digit of -2 becomes 4300 as the minus sign removed the decimals and as the digit is 2 so 4321 became 4300.

7890.89 with a digit of -3 becomes 7000.


It’s easy, isn’t it?