How To Remove Decimals In Excel?

Select the cells you want to change

Go to the Home tab

In the Number group, click Decrease Decimal until the decimals are removed

Or right-click the selected cells and choose Format Cells

Select Number

Set Decimal places to 0

Click OK

Or use the shortcut Ctrl+1 to open Format Cells

Select Number

Set Decimal places to 0

Click OK

Or use the ROUND function in a formula, such as =ROUND(A1,0)

Or use INT or TRUNC if you want to remove decimals from the value in a formula

Suggested for You

Trending Today