HOW TO

Add leading zeroes to numeric fields in ArcGIS Pro

Last Published: June 13, 2024

Summary

When adding a stand-alone table or dataset formatted with leading zeroes in the numeric field to ArcGIS Pro, the zeroes are omitted from the attribute table by default. The leading zeroes can be re-added to the field by configuring the number format in the attribute table settings. This article provides the workflow to insert the leading zeroes in numeric field values in ArcGIS Pro.

The image below shows the NumberTestLong field without any leading zeroes in ArcGIS Pro. In this example, the leading zeroes are added to the NumberTestLong field.

The attribute table of the layer without leading zeroes in ArcGIS Pro

Procedure

  1. In the Contents pane, right-click the feature class, and click Data Design > Fields to open the fields view of the feature class.
Opening the fields view of the feature class from the Contents pane
  1. Click the cell in the Number Format column for the row of the target field to format.
  2. In the highlighted cell, click Options The Options icon to open the Number Format dialog box.
The Options icon in the fields view
  1. In the Number Format dialog box, click the Category drop-down menu and select Custom.
  2. For the Format string parameter, edit the number format specifiers as required. In this example, 000 is used. Click OK.
The Number Format dialog box
  1. Click Save on the ArcGIS Pro ribbon in the Changes group.

The image below shows the leading zeroes are added in the NumberTestLong field when viewed in the attribute table.

The attribute table of the layer with leading zeroes in ArcGIS Pro

Article ID: 000031181

Software:
  • ArcGIS Pro 3 1
  • ArcGIS Pro 3 3
  • ArcGIS Pro 3 2

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options