I tried to convert an Event to a shape file and when doing so, I noticed that the 2 tables I had Joined by a common numeric field, contained completely different numbers that did not match the original excel table. All the other data fields matched up, but for some reason the common field i used for the join had totally different numbers than the original excel table.
The common join field now had duplicate values that did not match the original file.
Anyone know what could be the reason for this and how to fix it?
Ive pasted both attribute tables below to show the mismatch in the numbers.