I have a polygon and I calcuate acres or square kilometers.

I know how to do this but every time I bring the polygon to ArcMap. I had to go to their column and set it up the numbers to display look like this 1594267 rather than 1,594,267 ?

I know you can manually set up the column's properties and set it as thousand separators but Is there a way around to make it permanently ?

I have screen shot that you can check this out here.

enter image description here

There are two files before and after.

  • couldn't see screenshot. you can post image here. – Brad Nesom Jun 1 '11 at 20:41
  • I asked a similar question: gis.stackexchange.com/questions/9272/… ... And from what I've seen so far, it can't be done. You'll have to do it by hand every time you wish to view the numbers a specific way. – Nathanus Jun 1 '11 at 21:26
  • corrected url for screenshot – Mapperz Jun 1 '11 at 23:13

If it is a one-time thing and just for display purposes, you could always consider calculating the numeric values into a string field and using the following VBA syntax to permanently format the string:

Format( [fieldname] , "#,###.##")

Just paste this code into ArcMap's field calculator and replace the fieldname.


If the data is in shape file
There is not a lot you can do to force this.
Other than to create an lyr file and use the lyr file to insert the data into your projects.
If I understand correct what you are asking.


If I'm understanding the question correctly and there is not an OOTB (Out Of The Box) solution to this, then it looks like it would be possible to use a python script to calcuate the "non-comma'd" field into a "comma'd" string field. Just link a custom button as an add-in to call your script and it'll be as simple as clicking that little button, and BOOM! Magic! A new field with commas!


You could write a few lines in Python and paste into the python box each time. Or make into a toolbox. You could also just run this script on all your shapefiles once a day.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.