# How to Round Numbers Without Formula in Excel & Google Sheets

Written by

Reviewed by

*This tutorial demonstrates how to round numbers without a formula in Excel and Google Sheets.*

## Round Numbers

Say you have the following data set with values in Column A.

You could use the ROUND Function to round the values in your dataset, but Excel also has a few ways to round up, round down, or chop off numbers without a formula.

### Change the Number of Decimals

One rounding method is to use the decrease or increase decimal buttons.

#### Round With Decrease Decimal

- First, select the cells with values you want to round (A2:A6).
- Then in the
**Ribbon**, go to**Home**. - In the
**Number**group, click on the**Decrease Decimal**icon. The decimal places go down by the number of times you click on this button. In this example, clicking two times rounds all values to two decimal places.

As a result, the numbers of decimal places decreases.

#### Increase Decimal Places

To increase decimal places, you can change how a value is rounded by increasing the number of decimal places. Say you want to increase decimal places from 2 to 5.

- First, select the cells (A2:A6).
- Then in the
**Ribbon**, go to**Home**. - Press
**Increase Decimal**(here, three times).

As a result, the number of decimal places increases.

## Round With Number Formatting

- To round numbers using a number format, (1) select the cells with values you want to round (A2:A6). Then in the
**Ribbon**, (2) go to**Home**, and (3) select the**Number Format**icon in the lower right corner.

- This opens the
**Format Cells**window. In it, (1) select the**Number**tab, then under**Category**, (2) choose**Number**. (3) In the**Decimal places**box,**specify the number of decimal places**. (4) Press**OK**.

This rounds the values to the number of decimals you selected.

### Custom Format

You can also round numbers with a custom format with these steps:

- Select the cells with values you want to round (A2:A6), and
**right-click**them. From the list, choose**Format Cells…**

- In the
**Format Cells**window, click on (1)**Number**and (2) choose**Custom**from the list. In the**Type**box (3) enter the format you want.

In this example, entering**0.00**formats the values to two decimal places.

(4) Press**OK**.

As a result, all selected values have two decimal places.

## Round Numbers in Google Sheets

In Google Sheets, you can round numbers using a custom number format with these steps:

- Select the cells with values you want to round. Then in the
**Toolbar**, click the**More Formats**icon.

From the drop-down list, choose**More Formats > Custom number format**.

- In the
**Custom number formats**window, enter the format you want.

In this example, entering**0.00**formats the values to two decimal places.

Click**Apply**.

As a result, all selected values are displayed as numbers with two decimal places.