English

How To: Round numbers in an attribute table to a given number of decimal places

Summary

The instructions provided describe how to round values in an attribute table to the given number (N) of decimal places using the Field Calculator or the field properties.

Procedure

Field Calculator

  1. Open the attribute table.
  2. Right-click the field heading and click Field Calculator from the context menu.
  3. Select the Python radio button at the top of the Field Calculator.
  4. Paste the following Python expression into the Field Calculator text box.
round(!FIELDNAME!,N)
  1. Replace FIELDNAME with the field to be rounded and N with the number of decimal places to round the values.
  2. Click OK to execute the calculation.

Field Properties

  1. Open the attribute table.
  2. Right-click the field heading and click Properties... from the context menu.
  3. Click the Number Format ellipsis button.
Image of the ellipsis button in the Number Format section of the Field Properties dialog.
  1. In the Numeric category, set the number of decimal places to round the values in the Rounding section. Click OK.
Image of the Rounding section in the Number Format dialog.
  1. Click OK.

Related Information

Last Published: 9/17/2020

Article ID: 000011204

Software: ArcMap 10.8.1, 10.8, 10.7.1, 10.7, 10.6.1, 10.6, 10.5.1, 10.5, 10.4.1, 10.4, 10.3.1, 10.3, 10.2.2, 10.2.1, 10.2, 10.1, 10