Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

Common questions and answers.

Entire collection of data resources.

Latest Data News

RSS Feed icon

Baking a cake without ingredients

Where has John Thompson Gone?

The Gray Lady Speaks

How to Measure Affordable Housing? Include Transportation Costs

Maybe just a nothing burger, but. . .

Data Services Knowledge Base


I have run into an ArcMap mxd file that has a cell that I am interested in joining to that is defined as 'string'. This is happening in the counties template within my ArcGIS version 9. The cell has a 5 digit value representing a state and county mixed FIPS code (i.e. 26183 ) How do I go about converting the cell to a numeric one?


You can add a new field to the counties attribute table within ArcMap and make it numeric type (ie., short integer, long integer, double). This is done through the options tab on the bottom of the attribute table. You can define the cell at that point as sort integer or such. After that right click on the new field and choose to calculate. Set the new field equal to the FIPS cell.

Related Question Groups: