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

Get support with AI

Resolve your issue quickly with the Esri Support AI Chatbot.

Start chatting now

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Start chatting now

Go to download options