Hi.. I have an excel in which the values are in degree minute second format. I want to convert all this in decimal degrees by a single tool but the tool display xy data is not highlighting even i can't add a new field in the excel to calculate it again. please tell me what should i do?
I have used an equation in excel to convert DMS to DD. Since the Longitude value is from West, I have introduced the negative sign.
The cursor position of a few values were modified, to extract the correct value.
Please find attachment below.
Thanks a lot .. can you please tell me about that equation??
Those dms text strings look well formatted so the convert coordinate notation tool would work on this data.
sir this is the excel.
Thanks Jayanta.. PFA excel sheet.
I suspect that your data are not in numeric format. In order for it to be converted, your degrees, minutes and seconds would need to be in separate columns. If they are in one column, then the data need to be parsed in excel and decimal degrees calculated from it
Hi Sakshi,
Could you attach a sample excel sheet of the existing data available with you?
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
