HOW TO

Retain zeros after decimal points in ArcMap attribute table fields

Last Published: September 18, 2020

Summary

It is sometimes necessary to retain zeros after decimal points in ArcMap attribute table field values. In this article, the CGPA records of university students must be rounded to two decimal places; however, the zeros after the decimal point are not displayed. For example, 3.50 is displayed as 3.5, and 3.00 is displayed as 3.

Image showing the zeros after the field decimal points are not displayed in ArcMap attribute table.

Procedure

To retain zeros after a decimal point in an attribute table field value in ArcMap, enable the Pad with zeroes option from the Number Format dialog box as described in the workflow below.

  1. In Table Of Contents, under Layers, right-click the layer, and click Open Attribute Table.

Image showing how to open the attribute table for a layer in ArcMap.

  1. In the attribute table, right-click the field heading, and click Properties... to open the Field Properties dialog box.

Image showing how to open the Properties dialog box for a field in an ArcMap attribute table.

  1. Click the Number Format ellipsis Image showing the Number Format ellipsis button icon. button.

Image showing the Number Format ellipsis button.

  1. In the Number Format dialog box, select Numeric from the Category list.

  1. Select Number of decimal places under Rounding, and type the number of decimal places. In this example, 2 is entered.

  1. Check the Pad with zeros option.

  1. Click OK to close the Number Format and Field Properties dialog boxes.

Image showing the steps to change the number format, and pad the field values decimal places with zeros in the Number Format dialog box.

The image below shows zeros displayed after decimal points.

Image showing the zeros are displayed in the decimal places in the ArcMap attribute table.

Article ID: 000023900

Software:
  • ArcMap

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