Degrees, minutes, and seconds (**DMS**) are often used to indicate the **Angular Measurements**. In this article, we will learn how to convert the degrees decimal minutes to decimal degrees in **Excel**.

**Table of Contents**hide

**Download Practice Workbook**

You can download the workbook and practice with them.

**Degrees Decimal Minutes and Decimal Degrees**

**Degree Decimal Minutes** (**DDM**) is represented by the symbol ‘**°**’, and ‘**‘**’ which respectively for degrees, and minutes. For example, **20° 16 ‘ **denotes an angle of **20 **degrees and **16 **minutes.

**Decimal degrees** (**DD**) is a notation for expressing geographic coordinates as decimal fractions of a degree in latitude and longitude. The **decimal degrees** are calculated as follows:

**Decimal degrees = Degrees + (Minutes/60)**

Or,

**dd = d + m/60**

Angles with **d** integer degrees, **m** minutes are as **d° m’**.

**Calculation for Converting Degrees Decimal Minutes to Decimal Degrees**

**60 **minutes is equal to **one **degree:

**1° = 60′**

**1/60** degrees equals **one **minute:

**1′ = (1/60)°**

And, we already know that **Angles **with **d** integer degrees, **m **minutes are **d° m’**. Also, **dd **stands for decimal degrees and is equal to, **dd = d + m/60**.

For example, let’s see the calculation to convert **20 **degrees and **16 **minutes to decimal degrees.

**20° 16′**

**= 20° + 16’/60**

**= 20.27°**

**2 Methods to Convert Degrees Decimal Minutes to Decimal Degrees in Excel**

To convert degrees decimal minutes to decimal degrees we are going to use the following dataset which contains some degrees decimal minutes (**DDM**) in column **B**. And we will see the conversion in a different column name **Decimal Degrees **(**DD**). We can convert the angular dimension in two different ways in excel. Let’s go through the methods to convert the angular measurements.

**1. Apply Simple Formula to Convert Degrees Decimal Minutes to Decimal Degrees in Excel**

Excel has no built-in function or formula to convert the angular measurements. Even then we can convert the angular dimensions in Excel. We can use the formula shown in the above sections of the article. But to use that formula, we must remove the degree and minutes symbols first. That’s the reason we put another column named **Minutes **in our dataset. So, let’s see the procedure down to** convert the degrees decimal minutes to decimal degrees.**

**STEPS:**

- Firstly, select any of the degrees decimal minutes cells. So we select
**B5**. And by selecting the cell you are able to see the value in the formula bar. - Secondly, copy the degree symbol ‘
**°**’.

- After that, select the range
**B5:B10**.

- Next, go to the
**Data**tab from the ribbon. - Then, click on the
**Text to Columns**command under the**Data Tools**group.

- This will appear in the
**Convert Text to Columns Wizard**. - After that, choose the file type
**Delimited**. - Then, click on
**Next**. And you are done with**Convert Text to Columns Wizard Step 1**.

- Further, check-mark the box
**Other**under**Delimiters**.

- Now, paste the copied degree symbol ‘
**°**’ to the box beside**Other**. - And, click on
**Next**. And, you are finished with**Convert Text to Columns Wizard Step 2**.

- Furthermore, select
**General**in the**Column data format**selection menu. - And, finally, click on the
**Finish**button.

- This will appear in a Microsoft dialog box for your confirmation.
- Click on the
**Ok**button.

- And, you can see the degrees and minutes are separated now and the symbol of the degrees is removed.

- Secondly, by the same token, we need to remove the minute’s symbol ‘
**‘**’. - In that, choose any of the minute cells. As a result, we choose cell
**B5**. You may also see the value in the formula bar by selecting the cell. - Copy the ‘
**‘**’ sign for minutes.

- After that, choose the
**C5:C10**range. - Then, from the ribbon, select the
**Data**tab. - After selecting the tab, in the
**Data Tools**group, select the**Text to Columns**command.

- The
**Convert Text to Columns Wizard**will display. - Select
**Delimited**as the file type. - Next click on the
**Next**button. And that’s it for the**Convert Text to Columns Wizard**’s first step.

- Also, under
**Delimiters**, tick the box**Other**. - Place the copied minutes symbol ‘
**‘**’ in the box next to**Other**. - Now, click
**Next**.

- Additionally, in the
**Column data format**options menu, pick**General**. - Last but not least, hit the
**Finish**button.

- And, as you can see, the degrees and minutes have been split, and the minute’s symbol has been eliminated.

**PRINCIPAL STEPS:**

- First, select the cell, where you want to see the conversion. So, we select cell
**E5**. - After that, type the formula there.

`=B5+C5/60`

` `

- Now, if you click on the resulting cell, the formula will show in the formula bar.

Here, **B5 **is the degree and **C5 **is the minutes. We are using the formula **Decimal degrees = Degrees + (Minutes/60)**.

- After that, drag the
**Fill Handle**over the range**E6:E10**.

- And finally, the degrees decimal minutes are converted to decimal degrees.

**Related Content: How to Fix Convert to Number Error in Excel (6 Methods)**

**Similar Readings:**

**How to Convert Percentage to Decimal in Excel (7 Methods)****Convert Hours and Minutes to Decimal in Excel (2 Cases)****How to Convert String to Double in Excel VBA (5 Methods)****Bulk Convert Text to Number in Excel (6 Ways)****How to Convert Text to Number with Excel VBA (3 Examples with Macros)**

**2. Excel User-Defined Function to Transpose Degrees Decimal Minutes to Decimal Degrees**

We are now creating a user-defined function using the** Excel VBA** to convert the degrees decimal minutes to decimal degrees. Let’s demonstrate the steps below about how we can create the function and use the function in our spreadsheet.

**STEPS:**

- In the beginning, go to the
**Developer tab**from the ribbon. - After that, click on
**Visual Basic**to open the**Visual Basic Editor**. - Another way to open the
**Visual Basic Editor**is simply to press**Alt + F11**.

- Or, right-click on the sheet, then select
**View Code**.

- Next, go to
**Insert**and select**Module**from the drop-down menu.

- After that, copy and paste the
**VBA code**below.

**VBA Code:**

```
Function Decimal_Degrees(Degree_d As String) As Double
Dim degrees As Double
Dim minutes As Double
Degree_d = Replace(Degree_d, "~", "°")
degrees = CDbl(Left(Degree_d, InStr(1, Degree_d, "°") - 1))
minutes = CDbl(Mid(Degree_d, InStr(1, Degree_d, "°") + 1, _
InStr(1, Degree_d, "'") - InStr(1, Degree_d, "°") - 1)) / 60
Decimal_Degrees = degrees + minutes
End Function
```

- Then, save the code by pressing
**Ctrl + S**.

- This will create a function named
**Decimal_Degrees**. - Now, go back to the workbook and select the cell where we want the converted result to appear. So, we select cell
**E5**. - And you can see a function is added to our spreadsheet.

- Type the formula we have just created.

**=Decimal_Degrees(B5)**

- Press
**Enter.** - And, if you click on the resulting cell, the formula will appear in the formula bar.

- Next, drag the
**Fill Handle**down to copy the formula.

- And, that’s it. We can now see the converted result.

**Read More: How to Convert String to Number in Excel VBA (3 Methods)**

**Conclusion**

By using the above methods you will be able to convert the degrees decimal minutes to decimal degrees in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the **ExcelDemy.com** blog!

**Related Articles**

**How to Convert Scientific Notation to Number in Excel (7 Methods)****Convert Hours and Minutes to Decimal in Excel (2 Cases)****How to Convert Exponential Value to Exact Number in Excel (7 Methods)****Convert Percentage to Decimal in Excel (7 Methods)****How to Convert String to Long Using VBA in Excel (3 Ways)**