See all How-To Articles

How to Remove Decimals in Excel & Google Sheets

This tutorial demonstrates how to remove decimals in Excel and Google Sheets.

 

remove decimals initial data

 

Remove Decimals Using Cell Formatting

Say that you have the following data set containing decimal numbers.

 

remove decimals initial data

 

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.

 

remove decimals cell formatting 1

 

2. In the Format Cells, window, (1) go to the Number category, (2) set 0 Decimal places, and click OK.

 

remove decimals cell formatting 2

 

As a result, all numbers are rounded to the nearest whole number.

 

remove decimals cell formatting 3

 

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).

 

remove decimals without rounding 1

 

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).

 

remove decimals with rounding 1

 

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.

 

google sheets remove decimals cell formatting 1

 

2. In the Custom number formats window, enter 0 for whole numbers, and click OK.

 

google sheets remove decimals cell formatting 2

 

As a result, all numbers are rounded to the nearest whole number.

 

google sheets remove decimals cell formatting 3

 

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.