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

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Not any more: NY vs FL

Tools: Data as Text

More fun with names

Counting Same-Sex Couples

The Antidote for “Anecdata”: A Little Science Can Separate Data Privacy Facts from Folklore

Data Services Knowledge Base

Q:  

I have an excel file that I want to join to an Arcmap template. My file has a 'previous sample' column that has 1 and 0 values in it. Every time I try to do the join the 'previous sample' variable is not listing in my attributes table. What is going on?

A:  

When you have values that start with a leading 0 they will be dropped as a default. To maintain those numbers you will need to define the cell as 'text'. You can do that through the format tab in excel.

Related Question Groups: