For different purposes you may need to present a number rounded up to 2 decimal places. Our agenda for today is to show you several ways to round numbers to 2 decimal places. For conducting the session, we are using Excel 2019. You can use your preferred one.

**Read More: **How to Round up Decimals in Excel (4 Simple Ways)

Before diving into the big picture, let’s get to know about today’s workbook.

In this workbook we have a basic table for students and their scoring out of 1000. Using this table we will see how to round numbers to 2 decimal places.

To keep it simple we have brought this table to you, where Average score is in decimal values. In a real scenario, not all time averages will be fraction values and at the same time your data sets may have other fraction values.

## Practice Workbook

You are welcome to download the practice workbook from the link below

## 1. Round Numbers to 2 Decimal Places using Excel Format Feature

### 1.1. Number Formatting

Excel provides a format feature, using that you can round values easily.

On the *Home* tab you will find the *Number* section. From there you can format your values.

For the purpose of comparing the original and rounded values we have copied the original values (Average column) to another column.

Now select any of the values and explore the *Number* section for that one.

For a number having more than 2 decimal places (unless you have something predefined) you should see it’s in the format of the *General* category.

Now, Click on the *list icon* next to the category name. You will find a number of categories.

Select the category called Number.

The value will be rounded to 2 decimal places and the format will be changed to *Number* from *General*.

Let’s try another way of rounding up to 2 decimal points.

Explore the *Number* section again. You will find the *Decrease Decimal option*.

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

Click that for the number of times you need to reach 2 decimal places. In this example, we clicked a couple of times since we had 4 decimal places.

### 1.2. Custom Formatting

Excel provides you the option to choose your customized format.

Explore the *Number* section and Click the *list icon* next to the category. You will find a number of options (did it earlier also).

At the bottom you will find an option called ** More Number Formats**.

Click ** More number Formats**, it will pop up a dialog box in front of you.

Now in this dialog box you will find an option called * Custom*. Selecting that option, you can insert your suitable format on the

*Type box*, though Excel has some predefined format created evaluating several case studies.

We have selected 0.00 since we need numbers up to 2 decimal places. Then hit *Enter* or click *OK*

We have got the number to 2 decimal places successfully.

You can choose your own way to insert formats. Let’s roll back a bit and for this 688.6667 value again go to the format box.

We have inserted “**#.##”** as format. Then clicking *OK (or by Hitting Enter)* we have got something like the image below

Now you choose the format you have inserted.

Selecting the cell, you want to format, go to the *format dialog box* again

Usually, your inserted formula will be at the bottom of the *format type*. So *Scroll Down* and select the format.

It worked perfectly. Similar to this you can form your format for any type of input in Excel.

Now you can use any of the Number Formatting techniques or Custom Formatting techniques for the rest of the values in the example sheet.

## 2. Round 2 Decimal Places Numbers using Formula

### 2.1. Round using ROUND function

For rounding a number you can use a function called **ROUND**.

The syntax for this function is

`ROUND(number, num_digits)`

**number: **The number you want to round

**num_digits: **The number of digits to which number should be rounded

You can know more about the **ROUND** function by exploring Microsoft Support site.

Since our agenda is to round numbers by 2 decimal places so in the following examples, we will use 2 in the placeholder for *num_digits*.

We have written the **ROUND** function for the average score of *Jesmin*. And from a number of 4 decimal places it provided a number to 2 decimal places.

If you notice, you will see in the *Average* column the number was *748.6667*, but in the *Rounded Average* column the value is *748.67*.

*Hope you can remember, whenever the leaving digit is going to be more or equal 5, 1 is added to the right most remaining digit. ***ROUND** function adapts the same method.

Let’s write the function for the next value.

Here, the earlier value was *749.3333*. When we wrote the **ROUND** function for converting the number to the format of 2 decimal places, it gave *749.33*, as the last leaving digit was 3 (less than 5).

Now for the rest of the values, write the function or you can exercise the Excel **Autofill** feature.

Since it’s time to practice, better write the function.

### 2.2. Round using ROUNDUP function

Similar to the **ROUND** function you can use the **ROUNDUP** function.

For syntax you will not find any dissimilarities between **ROUND** and **ROUNDUP**

`ROUNDUP(number, num_digits)`

**number: **The number you want to round up

**num_digits: **The number of digits to which number should be rounded up

You can know more about **ROUNDUP** function exploring Microsoft Support site.

Write the function in Excel.

You might wonder why you should use **ROUNDUP** instead of **ROUND**, since the syntax is the same and the result is the same as well!

The **ROUNDUP** function returns numbers in its upper limit or ceiling closest to the original number.

Here our number was *748.6667* and our aim was to get up to 2 decimal places.

Writing the formula, we have got 748.67 which is higher than the original *748.6667*

Let’s observe another value here.

Using **ROUNDUP** for the *749.3333* we have got *749.34*.

Do the same for the rest of the values.

### 2.3. Round 2 Decimal Places using ROUNDDOWN function

Rounding a number can be done by the **ROUNDDOWN** function. The name says the whole story, this function will return the number towards the closest value in downwards direction.

Syntax is still same as **ROUND** or **ROUNDUP**

` `

`ROUNDDOWN(number, num_digits)`

**number: **The number you want to round down

**num_digits: **The number of digits to which number should be rounded down

You can know more about **ROUNDDOWN** function exploring Microsoft Support site.

Write the function in Excel.

You will find the number like this. It will return numbers in such a way that the decimal values are closer to 0.

Where for the *ROUND* function, 2 decimal places format value of *748.6667* was *748.67*, for *ROUNDDOWN* function it’s 748.66

Write the functions for the rest of the values for better understanding.

### 2.4. TRUNC Function

One function that may come to your mind is **TRUNC**.

The syntax for **TRUNC** is also similar to the **ROUND**.

`TRUNC(number, num_digits)`

**number: **The number you want to truncate

**num_digits: **The precision of the truncation.

You can know more about the **TRUNC** function exploring Microsoft Support site.

The *num_digits* parameter for **TRUNC** function is optional. If you don’t provide it, it will be 0 by default.

The **TRUNC** function also aims to provide decimal place values close to 0. This function will provide you a value that is lesser to the original value. Do the same for the rest of the values.

## Conclusion

That’s all for the session. We have tried listing out several ways to round numbers to 2 decimal places. Hope that will help you. Feel free to comment if anything seems difficult to understand. Let us know which of the methods you have liked most and are going to use.

You can also let us know your way of rounding numbers to 2 decimal places.

## Calculator

You can use today’s practice workbook as a calculator to count round numbers.

You will find a sheet called *Calculator*. Explore the sheet.

We have set the calculator in such a way, so that you can choose your desired number of decimal places.

Select the method you want to use from the drop down *Choose Method* section. Then Insert your number and preferred decimal places. It will provide you with the result.

One example has been done for you.

## Further Readings

- How to Round Numbers in Excel Without Formula (3 smart ways)
- Excel Round to Nearest 100 (6 Quickest Ways)
- Excel round to nearest 10000 (5 Easiest Ways)
- How to Round Off Numbers in Excel (4 Easy Ways)
- How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)
- Using Excel to Round to Nearest 1000 (7 Easy Ways)
- Excel Custom Number Format Multiple Conditions
- How to Apply Accounting Number Format in Excel! (Easy way)