HOW TO

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

Last Published: April 1, 2022

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.
Click 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.
Set the number of decimal places in the Rounding section of the Number Format dialog.
  1. Click OK.

Article ID:000011204

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic