To round data values in the worksheet, use the ROUND(X,Y) function in the worksheet. To do this:
- Select the data you wish to round.
- Click Data | Data | Transform.
- Enter the Transform equation, using the ROUND(X,Y) function, where x is rounded to y digits after the decimal point.
- Click OK and the data is rounded.
For example, use the Transform equation of B=ROUND(B,1) to round 12345.678 in column B to 12345.7, one digit after the decimal point.
Updated February 9, 2017