Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
couldn't see screenshot. you can post image here. – Brad Nesom Jun 1 '11 at 20:41
I asked a similar question:… ... 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
up vote 1 down vote accepted

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.

share|improve this answer

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.

share|improve this answer

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!

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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