In this video I convert Longitude and Latitude from Degree Minutes (DM) to to Decimal Degrees (DD) in Excel. I apply the Text-to-column tool, then I use a find and replace to clean up the numbers. ONce that is done I apply a formula that converts minutes to degrees and adds it to degree to get the final decimal degree for the sheet.
20 окт 2024