How to remove the decimal point and get an integer in excel

Setting method: First open the excel table that needs to be operated, select the cells that need to be processed; then press "ctrl 1" to bring up the "Set Cell Format" window, and select "Value" in the category drop-down list "; then enter "0" in the "Decimal Places" input box; and finally click "OK".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open an Excel document that needs to be processed, and select the data that needs to be processed.

Press CTRL 1 to bring up the Format Cells dialog box, and click the "Value" option with the mouse.

In the pop-up content on the right, we set "0" in the input box to the right of "Number of decimal places".

#After clicking OK, the data in the table will remove all numbers after the decimal point.

Related learning recommendations: excel tutorial

###

The above is the detailed content of How to remove the decimal point and get an integer in excel. For more information, please follow other related articles on the PHP Chinese website!