Supposing we have a purchase table as below screen shot shown, and now we need to remove digits after decimal for values in Amount Column. Excel functions can help you to remove digits after decimal easily. You can do as follows:

INT function: In a blank cell besides the value you will remove digits after decimal, enter the formula =INT(E2), and the drag the Fill Handle to the range you need.

Notes:
(1) In the formula =INT(E2), E2 is the cell that you will remove digits after decimal.
(2) INT function can also remain certain places of digits after decimal. For example, to remove all digits except the first one after decimal, you can apply the formula =INT(E2*10)/10.

TRUNC function: Besides the value you will remove digits after decimal, enter the formula =TRUNC(E2,0) into a blank cell, and then drag the Fill Handle to the range you need.

Notes:
(1) In the formula =TRUNC(E2,0), E2 is the cell you will remove digits after decimal, 0 means removing all digits after decimal;
(2) To remove all digits but first one after decimal, you can apply the formula =TRUNC(E2,1);

Tip: Remove formulas but keep formula results: (1)select  all formula cells; (2) copy these formula cells with pressing the Ctrl + C keys at the same time; (3) right click the first cell of destination range, and select Values below Paste Options in the context menu.
By the way, If you have Kutools for Excel installed, you can apply its To Actual feature to quickly convert all formulas to their formula results with only one click. See screenshots:

Batch add decimal point to existing numbers in a column/list without formula

As you know, decimal point can be automatically added with the specified decimal places when you typing numbers by Excel options > Advanced > Automatically insert a decimal point. However, this option will affect the whole worksheets. What’s about only automatically inserting decimal points to existing numbers in a specified range in Excel? Try Kutools for Excel’s Operation utility!

All functions don’t modify original values in Excel, but sometimes you may just need to change original values. To remove digits after decimal from original values directly, you can apply the Round utility of Kutools for Excel.

1. Select the cells that you will remove digits after decimal, and then click the Kutools > Round.

2. In the opening Round without Formula dialog box, type 0 in the Decimal place box, check the Rounding down option, and click the Ok button.

Round a range of cells in Excel

Round / round up / round down a range of cell in Excel

Round to nearest even or odd number in Excel