Is This Content Helpful?
We're glad to know this article was helpful.
Working with an Excel table containing field values that consist of long numbers and hyphens can cause issues when the table is imported for use in ArcMap.
For example, attempts to perform a join operation in ArcMap fail when using the Parcel ID with another ID from another table (either as a number or text field), as the Parcel ID field contains the value of '17-80009-6578-4657-002'.
When formatting the Excel table for use in ArcMap, using the Find and Replace function in Excel to remove the hyphens converts the values to the scientific notation format as Excel automatically shortens the value to '1.78001E+17' due to the length. However, attempts to convert the value from scientific notation to the decimal format in Excel using the Format Cell option returns an inaccurate value such as '178000965784600000'.
To perform a successful join operation for fields that contain a long string of numbers and hyphens, ensure the following criteria are met:
Note: B2 represents the cell containing the long string of numbers with hyphens.