# How to Remove Decimals in Excel & Google Sheets

This tutorial demonstrates how to remove decimals in Excel and Google Sheets. ## Remove Decimals Using Cell Formatting

Say that you have the following data set containing decimal numbers. In order to format cells to remove decimals, follow the next steps.

1. (1) Select a range with decimal numbers (B2:B8), (2) right-click the selected area, and (3) choose Format Cells… You can also, in the Ribbon, go to the Home tab, and click on the Format Number icon in the right bottom corner of the Number group. 2. In the Format Cells, window, (1) go to the Number category, (2) set 0 Decimal places, and click OK. As a result, all numbers are rounded to the nearest whole number. ## Remove Decimals Without Rounding

If you want just to remove decimals, without rounding, you have to use the TRUNC function. In order to achieve this, create one helper column, and in cell C2, enter the formula:

=TRUNC(B2)

and expand the formula to the last row with data (row 8). As you can see decimals are now truncated (not rounded) from the original number, and you got whole numbers without rounding.

## Remove Decimals With Rounding

You can also remove decimals and round numbers. To achieve, this you can use the ROUND function with 0 decimals. In cell C2, enter the formula:

=ROUND(B2,0)

and expand the formula to the last row with data (row 8). Apart from this, you can also use functions INT (which rounds decimal to a whole number), ROUNDUP, or ROUNDDOWN functions.

## Remove Decimals Using Cell Formatting in Google Sheets

1. (1) Select a range with decimal numbers (B2:B8), and in the menu, (2) go to Format > Number > Custom number format. 2. In the Custom number formats window, enter 0 for whole numbers, and click OK. As a result, all numbers are rounded to the nearest whole number. Note: Similar to Excel, you can also use functions:

• ROUND,
• TRUNC – to remove decimals without rounding
• INT, ROUNDUP, ROUNDDOWN – to remove decimals and round a number.