topic Re: Convert DMS from Excel to ArcGIS ? in Data Management Questions https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274888#M15833 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 19 Jan 2017 10:21:51 GMT FC_Basson 2017-01-19T10:21:51Z Convert DMS from Excel to ArcGIS ? https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274885#M15830 <HTML><HEAD></HEAD><BODY><P>I'm trying to&nbsp;display the coordinates (DMS2) in my excel file in ArcGIS for Desktop by using the geoprocessing tool "Convert coordinate Notation" but i'm Always getting&nbsp; the same error "&nbsp;999999 : Error executing function". I cannot figure it out why it will not work ? Can somebody help me with this ? The excel file is attached ? </P></BODY></HTML> Thu, 19 Jan 2017 09:25:45 GMT https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274885#M15830 JoSurinx 2017-01-19T09:25:45Z Re: Convert DMS from Excel to ArcGIS ? https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274886#M15831 <HTML><HEAD></HEAD><BODY><P>The last row of the list of coordinates has the N and E swopped. &nbsp;Change the Latitude column to N and the Longitude column to E and it works.</P></BODY></HTML> Thu, 19 Jan 2017 09:43:40 GMT https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274886#M15831 FC_Basson 2017-01-19T09:43:40Z Re: Convert DMS from Excel to ArcGIS ? https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274887#M15832 <HTML><HEAD></HEAD><BODY><P>What a stupid mistake ! Thx very much to direct me to this error ! </P></BODY></HTML> Thu, 19 Jan 2017 10:18:48 GMT https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274887#M15832 JoSurinx 2017-01-19T10:18:48Z Re: Convert DMS from Excel to ArcGIS ? https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274888#M15833 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 19 Jan 2017 10:21:51 GMT https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274888#M15833 FC_Basson 2017-01-19T10:21:51Z Re: Convert DMS from Excel to ArcGIS ? https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274889#M15834 <HTML><HEAD></HEAD><BODY><P>Oh and don't forget to close this thread by marking the answer as correct. Thanks!</P></BODY></HTML> Thu, 19 Jan 2017 10:58:39 GMT https://community.esri.com/t5/data-management-questions/convert-dms-from-excel-to-arcgis/m-p/274889#M15834 FC_Basson 2017-01-19T10:58:39Z