Method: First open the excel table that needs to be operated, select the cells that need to retain integers; then right-click the mouse and select "Format Cells" in the pop-up right-click menu; then in the new window that pops up Click "Value", enter "0" in the "Decimal Places" input field; finally click the "OK" button.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
Open the Excel table and select the cell where you want to round the integer.
Right-click the cell with a yellow background and click "Format Cells" in the pop-up menu (pointed to by the red arrow in the picture)
Click "Number" (pointed by the red arrow in the picture)
Fill in the desired number in the "Number of Decimal Places" input box (red box in the picture) The required decimal places, here is an example of inputting "0", which represents rounding, and then click "OK" (pointed by the red arrow in the picture)
to get the rounded value The effect is as shown in the figure below
Related learning recommendations: excel tutorial
The above is the detailed content of How to retain integers in excel. For more information, please follow other related articles on the PHP Chinese website!