This article will show you how to round numbers in Excel without using formula. You will get to see several processes to round up, round down, and chop off decimal numbers in Excel. Here we will mainly see the options which include the built-in features. The processes are very simple, you can choose any process that you want.

**Table of Contents**hide

## 3 Simple Ways to Round Numbers in Excel Without Formula

Here in this article, we will work with the value of **PI **for instances. We will round this value into different decimal places. To insert the value of **PI** in your worksheet, write, **=PI()** in any cell.

As you can see this value has 14 decimal places.

### 1. Round Numbers with Decrease and Increase Decimal Commands in Excel

Excel has the built-in feature under the **Home** tab from which you can easily round up or round down your numbers.

#### 1.1 Decrease Decimal Places

To decrease the decimal places, execute the following steps.

**📌**** Steps:**

- First, go to the
**Home**tab and under the**Number**group, you will find the**Decrease Decimal**option. - Click it after selecting your cell. To convert this value to a
**5-decimal**place number, you have to click it**9**times as the number contains a total of**14**decimal places.

You will see the decimal places are reduced.

#### 1.2 Increase Decimal Places

Let’s work with the number 3.14159. In this step, we will simply do our job which is just a click away. Let’s explore the easy steps.

**📌**** Steps:**

- If you want to increase the decimal numbers from 5 decimal places to 7 decimal places, select the number first and click on the
**Increase Decimal**option two times under the**Home**tab.

- You will see 2 decimal places are added to your number.

### 2. Round Numbers from Format Cells Option

Let’s work with the value of **PI** again which has 14 decimal places. Here we will round the number by selecting the decimal places specifically.

**📌**** Steps:**

- To open the Number Format, select the specific cell for which we want to do the formatting.
- Now press
**Ctrl+1**. This is will take you to the**Format Cells**option.

You can also select the **Number Format** option under the **Home** tab to get here.

- After clicking this, you will get the
**Format Cells**Dialogue box where you have to select the**Number**category. - In this
**Decimal places**box, reduce the decimal places to 5.

- You can also open this box by pressing the
**Format Cells**option after pressing the right button of your mouse to the cell. - After selecting specific decimal places, press
**OK**, and you will get to see the result.

**Note:**

This is the best option for rounding up numbers as you can select the decimal places specifically.

### 3. Use a Custom Format to Round Numbers

You can also round numbers using a custom number format in Excel. Just follow the steps below to do that.

**📌**** Steps:**

- To open the
**Custom**option, first, we will select the cell and then click on the**Format Cells**after pressing the right button of your mouse. - In the
**Format Cells**window, select**Custom**as Category. - In the
**Type**box, write 0.0000 which will make the number have 4 decimal places. - You can have a
**Sample**from which you can see the preview. - Now, after pressing
**OK**you will see the result that you want.

**Read More: Excel Custom Number Format Multiple Conditions**

## How to Round to Nearest Whole Number in Excel without Using Any Formula

So far, we have discussed, how to round numbers with the desired number of digits. In this portion of the discussion, we will see how to round numbers to the nearest whole numbers without using any formula. Apply the following steps to do that.

**📌**** Steps:**

- We will first set the location cells to a pre-fixed number format. Select the cells first.
- Then press
**Ctrl+1**.

- The
**Format Cells**window will open up. Now, go to the**Number**section and set the**Decimal places**box to 0. - Then press the
**OK**button.

- Now, copy the numbers and select the location cell where to paste them in rounded form.
- Then
**right-click**your mouse. - Select
**Paste Values**from the**Paste Options**.

- Now, we will see that each of the numbers is rounded to their nearest integer form. For example, 100.3 to 100, or 1.99 to 2.

## Conclusion

In this article, you get to see several processes on how to round numbers in Excel without using formula. Here you also see the process of chopping off the decimal point. Although many formulas can be used to perform these tasks, you will find it easy to do these tasks by using these built-in features. Hope you will like this article. Follow **us** to get more useful articles.

## Further Readings

**Excel Round to Nearest 100 (6 Quickest Ways)****Excel round to nearest 10000 (5 Easiest Ways)****How to Round up Decimals in Excel (4 Simple Ways)****How to Round Off Numbers in Excel (4 Easy Ways)****How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)****Excel Round to 2 Decimal Places (with Calculator)****Excel Number Stored As Text [4 Smart Ways]****How to Add Leading Zeros in Excel (4 Quick Methods)****Using Excel to Round to Nearest 1000 (7 Easy Ways)**

Great!

Thanks for your feedback 🙂