ROUND can be used to round the ten digits in EXCEL. For example, input = round (a1; -1), where cell A 1 is the original data, and-1 is rounded to the left of the decimal point. Taking EXCEL2007 as an example, the setting method is as follows:

1, open an EXCEL file on the computer to enter.

2. Enter the required data in the corresponding cell.

3. At this time, enter the formula = round (a1; - 1)。

4. After the formula is entered, press Enter, and you can see that the original data has been rounded to ten digits.