In Excel by default the unit of angle is radians. But we may want the angle in degrees. It’s not that hard work to convert radians to degrees in Excel. In this article, we will show the way to convert radians to degrees.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## What Are Radians and Degrees?

Radians and Degrees are two units to measure the angle. The angle created at the center of a circle is considered 360° in degrees unit whereas it is considered as 2 in radians. Taking this relation into consideration we can easily convert radians to degrees and vice versa.

## 3 Methods to Convert Radians to Degrees in Excel

Converting angles from radians to degrees is a very simple task in Excel. But it is required sometimes. Here we will show 3 simple but useful methods to convert angles in radians to degrees.

### Method 1: Convert Radians to Degrees Using DEGREES Function

Excel has an in-built **DEGREES function** to convert the radians input into degrees directly. The steps to do that are given below.

**Step 1: **First we have to select the cell to store the result. In our case the cell is **C6**.

**Step 2: **Then we have to enter the cell and write the following formula.

`=DEGREES(B6)`

Here, **B6** is the cell for radians input.

**Step 3: **We have to press **ENTER** and use **Fill Handle **to copy the formula to the cells below.

We can see the results in degrees in the cells.

**Read More:** **How to Convert Measurements in Excel (2 Quick Ways)**

### Method 2: Convert Radians to Degrees using PI Function

Instead of using the **DEGREES **function, we can use mathematical operations with the **PI function** in Excel to convert radians to degrees. We will show the steps to do that below.

**Step 1: **First we need to select the cell to show the result. In our case the cell is **C6**.

**Step 2: **We need to write the formula given below in the cell.

`=B6*180/PI()`

Here, **B6 **is the cell for radians input,

We used multiplication(*****) and division(**/**) math operators with numerical value 180. Here, we have multiplied radian value with 180 and then divided by the pi value.

**Step 3: **We have to press **ENTER **and use **Fill Handle **to copy the formula to the cells below.

We can see the result for each cell.

**Read More:** **How to Convert Units in Excel (3 Handy Methods)**

### Method 3: Convert Radians to Degrees by VBA Code

We can also convert the angles in radians to degrees easily by using the **Visual Basics for Applications**(**VBA**) code. We are showing the steps to do that.

**Step 1: **At first We need to press **ALT+F11 **to open the **VBA **window. We have to right click the sheet where we want the code to work. Then we have to select **Insert > Module**.

**Step 2: **The Module window will show up. We need to write the following code in the window.

```
Sub calculate_rad_to_deg()
For Each input_cell In Selection
input_cell.Offset(0, 1).Value =Application.WorksheetFunction.Degrees(input_cell.Value)
Next input_cell
End Sub
```

Here,

**calculate_rad_to_deg **is a sub-procedure,

**input_cell **is a variable,

**Offset(0, 1).Value **puts the result in the next cell of the input cell,

**Degrees(input_cell.Value) **is a VBA function to convert the input radians to degrees.

**Step 3: **Now we need to close the window and select the range of cells whose values we want to convert to degrees.

**Step 4: **We need to select **Macros **from the **View **tab in the ribbon.

**Step 5: **The **Macro** window will show up. Now we need to run the code.

**Step 6: **After running the code we will see the values in degrees to the cells beside the input radians cells.

**Similar Readings**

**How to Convert Decimal Feet to Feet and Inches in Excel (4 Handy Methods)****Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)****How to Convert Kg to Lbs in Excel (4 Easy Methods)****Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)****How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)**

## How to Convert Radians to Degrees Minutes Seconds in Excel

So far we have seen the results of the converted degree which consist of values after the decimal point. We may want to convert the value into Degrees, Minutes, and seconds. We can easily do that in Excel. The steps are shown below.

**Step 1: **First we have to select the cell where we want the result. In our case the cell is **D5**.

**Step 2: **Then we need to enter the cell and write the following formula there.

`=TEXT(INT(C5),"0° ")&TEXT(INT((C5-INT(C5))*60),"0' ")&TEXT((C5*60-INT(C5*60))*60,"0.0")&""""`

Here, **C5 **is the input cell, we used the **TEXT** **function**.

**TEXT(INT(C5),”0° “) **is giving the output in degrees without fractional value,**Output:** “49° ”

**TEXT(INT((C5-INT(C5))*60),”0′ “) **here the fractional value of the result of the degree is separated and multiplied by 60 to show the Minutes results**Output:** “59′ ”

**TEXT((C5*60-INT(C5*60))*60,”0.0″) **is separating the fractional value from Minutes result and multiplying it by 60 to get the Seconds results.**Output:** “46.7”

Later, Excel concatenates all these results as we have used the concatenation operator (&).

**Step 3: **We have to press **ENTER **and use **Fill Handle **to copy the formula to the cells below.

We can see the result in each cell.

**Read More:** **How to Convert Feet and Inches to Decimal in Excel (2 Easy Methods)**

## Calculator: Radians to Degrees

In the practice worksheet, we have included a calculator which you can use to convert angles in radians to degrees.

## Conclusion

For historical reasons Excel measures angle in radians by default. But we may want the angle in degrees sometimes. In this article, we have shown 3 separate simple methods to convert radians to degrees. Hopefully, it will help you. If you have faced any problems following the methods or you have any suggestions, please let us know by comment.