# How to round .5 in Google Sheets and Excel

Sometimes, while working with numbers in Excel or Google Sheets, you may need to change a decimal to a whole number. To new users, they may find it to be challenging. In this article, we shall discuss methods and steps that can be used to round decimals in Google Sheets and Excel.

## To Round in Google Sheets

Here is the method that can be used:

The Format tool

Using the toolbar

Using the Round function

### 1. The Format tool

Here are the steps to follow when using this method:

1. Open an existing Google sheet or a blank one you wish to round.

2. Add the data to empty cells if you open a blank sheet.

3. Highlight the added data, then click on the Format tab on the menu.

4. Locate the Numbers button and hover the cursor over it.

5. Click on the Custom Number Format button.

6. Select the Whole number option (shown using a single zero), and finally click the Apply button.

### 2. Using the toolbar

Here are the steps to follow when using this method:

2. Add the data to empty cells if you open a blank sheet.

4.
Click on the Decreasing decimal icon on the toolbar. The number will be rounded off.

### 3. Using the Round function

Steps:

1. Open an existing Google sheet or a blank one you wish to round.

2. Click on an empty cell that will contain the function.

3. Type the equal sign (=) followed by Round (.

4. Select the cell you want to round, and then enter a comma followed by 0.

5. Finally, enter the closing bracket and hit the Enter button.

## To Round in Excel

Methods that can be used:

The Format cell tool

Using the Round function

### 1. The Format cell tool

Here are the steps to follow:

1. Locate the Excel application on your Pc, and then double-click to open it.

2. Click on the cell that contains the number you want to round.

3. Right-click to open the side-view menu and select the Format Cells button in the menu.

4. From the dialogue box, choose the Number button. Locate the Decimal places section and click on the down arrow to round the selected number.

### 2. Using the Menu bar

Here are the steps to follow:

1. Locate the Excel application on your Pc, and then double-click to open it.

2. Click on the cell that contains the number you want to round.

3. In the Home tab, locate the Number section.

4. Click on the Decreasing decimal icon to round the selected number.

### 3. Using the Round function

Here are the steps to follow:

1. Locate the Excel application on your Pc, and then double-click to open it.

2. Click on an empty cell that will contain the function.

3. Type the equal sign (=) followed by Round (.

4. Select the cell you want to round, and then enter a comma followed by 0.

5. Finally, enter the closing bracket and hit the Enter button.