Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to convert numbers with decimals into integers in excel?
How to convert numbers with decimals into integers in excel?
You can round 12.5 to 13, but still 12.5, but not 12 without changing its actual value, which will actually destroy the original data of the cell.

The specific operation steps of the former are as follows:

1, select cell A 1.

2, the right mouse button, in the drop-down list, select click set cell format.

3. Change the cell to a number format, leave 0 as a decimal, and then click OK.

4. At this time, although the cell shows 13, its actual data is 12.5.