topic Re: ArcGIS Pro altering a column from excel when imported in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144458#M6276 <HTML><HEAD></HEAD><BODY><P>The excel to table tool made the difference! THANKS</P></BODY></HTML> Wed, 22 Feb 2017 15:58:08 GMT JessieZarazaga1 2017-02-22T15:58:08Z ArcGIS Pro altering a column from excel when imported https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144456#M6274 <HTML><HEAD></HEAD><BODY><P>When I add a table from Excel, with a GEOid to match census tract GeoID numbers, ArcGIS Pro is changing the whole set of numbers into a single matching number: 2147483647. </P><P>This is a simple exercise to make a join- for my students- but they cannot make the join if the ID is not there!</P><P></P><P>thanks</P><P>Jessie</P></BODY></HTML> Tue, 21 Feb 2017 21:48:00 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144456#M6274 JessieZarazaga1 2017-02-21T21:48:00Z Re: ArcGIS Pro altering a column from excel when imported https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144457#M6275 <HTML><HEAD></HEAD><BODY><P>You didn't set the field properties 'explicitly' when saving the worksheet, so anything goes...</P><P></P><P><IMG __jive_id="327530" alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/327530_tabledemo.png" style="width: 620px; height: 214px;" /></P><P>PS&nbsp; I used the&nbsp;Excel to table tool</P></BODY></HTML> Tue, 21 Feb 2017 22:41:26 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144457#M6275 DanPatterson_Retired 2017-02-21T22:41:26Z Re: ArcGIS Pro altering a column from excel when imported https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144458#M6276 <HTML><HEAD></HEAD><BODY><P>The excel to table tool made the difference! THANKS</P></BODY></HTML> Wed, 22 Feb 2017 15:58:08 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-altering-a-column-from-excel-when/m-p/144458#M6276 JessieZarazaga1 2017-02-22T15:58:08Z