I have an excel table with parcel ID's (PINs). The PINs are in "number" format in excel. Iimported this excel table into ArcMap with the goal of joining them with the county parcel shapefile. I right click on the excel table>export>navigate to myfolder and save as a .dbf. I add the .dbf to my map and the data is not correct. When I export, my numbers change. Does anyone know how to fix this?
I imported the excel file with the parcel values as "text" format. After exporting this field to a dbase, I opened my attribute table, added a "double" type field, used the Field Calculator to equal this to the text field containing my parcels (new double field=text field from original excel file). This seemed to work without changing the values of my data and I was able to perform the join.