How to round to an integer in excel

How to round decimals into integers in excel: First open Excel; then select the cell range that needs to be converted into integers from decimals; finally press the "Ctrl Shift 1" key combination on the keyboard.

Recommended: "Excel Tutorial"

This tutorial will introduce how to quickly implement decimals through a new Excel document Convert to integer trick.

Right-click the Excel icon and select the Open command in the pop-up right-click menu.

#In order to improve understanding, the tutorial takes the following data as an example to convert the decimals of the data in column A into integers.

First select the cell range where we need to convert decimals into integers.

Then press the key combination Ctrl Shift 1 (number on the non-small keyboard) key combination on the keyboard.

The final result is as shown in the figure. The decimals in column A are converted into integers according to the rounding principle, and the original integers in column A remain unchanged.

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