I have an excel file which I am trying to join to a shapefile. The field on which the join will be based is Census Block ID - a 15 digit number.
When I import this excel file in ArcGIS Desktop 10.1, ArcMap automatically converts the 15 digit number into a 13 digit number (losing the 14th and 15th digit). This results in an incorrect join.
In order to have 15 digit numbers back, I tried the following with no success -
1. Change the numeric format in ArcMap. Although this produces more digits, it replaces last two digits (14th & 15th) with zeros.
2. Tried importing the file in Text and CSV format.
3. Exported the Shapefile attributes to a table. Combined my Excel file with that table. And, imported it back to ArcMap as a CSV.
The issue of losing last two digits still persists.
Does anyone have any clue? I would appreciate any suggestions you might have.