I am trying to convert to decimal degrees so I can import into ArcGIS.
Lat: 43°41'34.92"N
Long: 88°56'13.61"W
I have each number in thier own cell in excel
thanks for the help!
I am trying to convert to decimal degrees so I can import into ArcGIS.
Lat: 43°41'34.92"N
Long: 88°56'13.61"W
I have each number in thier own cell in excel
thanks for the help!
Try putting this code in a new module in vba:
Then use the function in your worksheet to convert what you need, using for example =ConvertDecimal(A1) where A1 would be the cell that contains the value you need to convert.Please Login or Register to view this content.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
To do this you have to open the VBA window (Alt+F11), right click on VBAProject(Your Workbook name) and click Insert -> Module. Then you double click on your new module and paste the code. Then you can use the function in your worksheets.
Sorry there was a small error in the formula:
Please Login or Register to view this content.
I just used this, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks