Traditional Culture Encyclopedia - Photography and portraiture - How to delete decimals from excel tables

How to delete decimals from excel tables

1. As shown in the figure, there are some numbers in the EXCEL table. Now you want to keep the integer. Double-click the number after the decimal point in the table and it will not appear.

2. If you only want to keep integers, just enter the function =trunc(A 1) in column B, as shown in the figure:

3. After the second step, press Enter, and then use fill handle to pull down the integer. Is it very simple, as shown in the figure: