There are two common ways to remove digits after a decimal place in Excel:

**Method 1: Use TRUNC Function**

**=TRUNC(B2)
**

**Method 2: Use INT Function**

**=INT(B2)**

Both of these formulas will remove all digits after the decimal place for the number in cell **B2**.

The following example shows how to use each formula in practice with the following dataset in Excel:

**Example 1: Use TRUNC Function to Remove Digits After Decimal in Excel**

We can type the following formula into cell **C2** to remove the digits after the decimal place in the value in cell **B2**:

**=TRUNC(B2)**

We can then click and drag this formula down to each remaining cell in column C:

Notice that each cell in column C returns the number in the corresponding cell in column B with the digits after the decimal place removed.

**Note**: You can find the complete documentation for the **TRUNC** function in Excel here.

**Example 2: Use INT Function to Remove Digits After Decimal in Excel**

We can type the following formula into cell **C2** to remove the digits after the decimal place in the value in cell **B2**:

**=INT(B2)**

We can then click and drag this formula down to each remaining cell in column C:

Notice that each cell in column C returns the number in the corresponding cell in column B with the digits after the decimal place removed.

Also notice that the results of this formula match the results from using the **TRUNC** function.

Both functions produce the same result so feel free to use whichever one you prefer.

**Note**: You can find the complete documentation for the **INT **function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Round to Significant Figures in Excel

How to Extract Decimal Number from String in Excel

How to Display Two Decimal Places Without Rounding in Excel