How to automatically erase zeros in excel

How to erase Excel numbers directly without rounding

Recommended: "excel tutorial 》

First start excel on the desktop

Open the document

We see the following table , there are a lot of fractions behind the personnel income.

Enter the formula =INT(D2) in the next cell. The INT function represents rounding the number down to the nearest integer, and click Enter.

#After pressing Enter, the integer has been extracted, as shown in the figure below.

Then pull down the cell fill box to complete the entire table. We see that the data is not rounded, but the integers are completely extracted.

The above is the detailed content of How to automatically erase zeros in excel. For more information, please follow other related articles on the PHP Chinese website!