Home  >  Article  >  Topics  >  How to remove the decimal point and get an integer in excel

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

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-28 15:25:5121134browse

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".

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

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.

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

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

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

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

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

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

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn