How To Add or Remove decimal In Excel

Oct 28, 2020 • edited Oct 31, 2020

How To Add or Remove decimal In Excel

This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function.

Int

The INT (Integer) function rounds a number down to the nearest integer (negative numbers become more negative).

Int Function in Excel, Positive Number

Int Function, Negative Number

Conclusion: the INT function only chops off decimals from positive numbers.

Trunc

The TRUNC (Truncate) function always chops off decimals.

Trunc Function, Positive Number

Trunc Function, Negative Number

The TRUNC function can keep any number of decimals and chop off the rest.

Keep Two Decimals

Keep Three Decimals

#Tutorial#How To#Functions#Round

How to use Concatenate function In Excel

How to Compare Two Columns in Excel