This wikiHow teaches you how to round values in a box using the “ROUND” formula, as well as how to use grid formatting to display values in a column as integers.
Step
Method 1 of 3: Using the Decimal Increase and Decrease Button
Step 1. Enter the data into the spreadsheet
Step 2. Mark the boxes with the values you want to round
To check multiple boxes, click the box that has the data and its position closest to the top-left corner of the sheet, then drag the cursor toward the bottom-right until all boxes are marked.
Step 3. Click the “Decrease Decimal” button to decrease the number of decimals
This button is labeled “ .00 →.0 ” and is displayed in the “Home” tab of the “Number” panel (the last button on the panel).
As an example: When you click the “Decrease Decimal” button, the number 4, 36 will become 4, 4.
Step 4. Click the “Increase Decimal” button to display more decimal numbers
With this option, you can return a more accurate value (and not a rounded number). This button is labeled “ ←.0.00 ” (displayed also in the “Number” panel).
Example: When you click the “Increase Decimal” button, the number 2.83 will become 2.834.
Method 2 of 3: Using the “ROUND” Formula
Step 1. Enter the data into the spreadsheet
Step 2. Click the box next to the data you want to round
After that, you can enter the formula into the box.
Step 3. Type “ROUND” into the “fx” field
This column is at the top of the spreadsheet. Type in an equal sign, followed by the “ROUND” formula like this: =ROUND.
Step 4. Type the opening parenthesis after “ROUND
” The contents of the “fx” column should now look like this: =ROUND(.
Step 5. Click the column with the data you want to round
The box location (eg “A1”) will be added to the formula. If you click the “A1” box, the formula in the “fx” column will look like this: =ROUND(A1.
Step 6. Type a comma, followed by the number of digits you want to round
For example, if you want to round the data in column “A1” to display only 2 decimal places, the formula you enter will look like this: =ROUND(A1, 2.
- Use 0 as the decimal point to round data to the nearest integer.
- Use negative numbers to round data by multiplying by 10. For example, the formula =ROUND(A1, -1 will multiply the data by the product of 10.
Step 7. Type the closing parenthesis to end the formula
Now, your final formula should look like this (for an example of rounding the data in the “A1” box to two decimal places: =ROUND(A1, 2).
Step 8. Press Enter or Returns.
The “ROUND” formula will be executed and the rounding result will be displayed in the selected box.
- You can replace the “ROUND” formula with “ROUNDUP” or “ROUNDDOWN” if you need to increase or decrease rounding to a specific decimal point.
- In addition, the “MROUND” formula functions to round data to the closest multiplication to the number you specify.
Method 3 of 3: Using Grid Formatting
Step 1. Enter the data series into an Excel spreadsheet
Step 2. Mark the boxes with the data you want to round
To check multiple boxes, click the box that has the data and its position closest to the top-left corner of the sheet, then drag the cursor toward the bottom-right until all boxes are marked.
Step 3. Right-click the marked box
The menu will be displayed afterwards.
Step 4. Click Number Format or Cell Formats.
The name of this option differs depending on the version of Excel.
Step 5. Click the Number tab
This tab is at the top or side of the window that appears.
Step 6. Click Number from the list of categories
It's next to the window.
Step 7. Select the number of decimals you want to round
Click the down arrow icon next to the “Decimal places” menu to display a list of numbers, then click the desired option to select it.
-
For example, to round 16, 47334 to display only 1 decimal number, select “
Step 1.” from the menu. After that, the data will be rounded to 16.5.
- For example, to round 846, 19 to an integer, select " 0 ” from the menu. After that, the data will be rounded to 846.
Step 8. Click OK
It's at the bottom of the window. The data in the selected box will be rounded to the point/number of decimals you specify.
- To apply this setting to all data on the sheet (including data that will be added later), click any part of the sheet to deselect the box, then select the tab " Home ” at the top of the Excel window. Click the drop-down menu on the “Number” panel and select “ More Number Formats " Set the number/decimal points (“Decimal places”) you want, then click “ OK ” to apply it as the primary data rounding setting in the file.
- In some versions of Excel, you need to click on the “ Format ", "choose Cells, and click on the tab “ Number ” to access the “Decimal places” menu.
