In Excel, there is an option called auto correct which you can use to add a degree symbol in a cell by using an abbreviation. Using Excel AUTO Correct to Add a Degree Symbol in a Cell You can also copy-paste into other cells or even you can insert a formula as well.

In the end, click on Insert and then close.

In the dialogue box, select “Latin-1 Supplement” from Subset and select the degree symbol from all the symbols.

Select the cell where you want to insert it and then go to Insert ➜ Symbols ➜ Symbol.

If you want to add a degree symbol just one time then you can also insert it from the symbol dialog box. Insert Degree Symbol from Symbol Dialogue Box The other way is to combine this formula with IF and ISNUMBER so that if there is will be a number in the cell it will combine that number with a degree. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.And if you want to add it with a number you just need to insert a formula like the one we have below. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Instant Connection to an Expert through our Excelchat Service This will change the radians into degrees mode in excel. In cell C2, we have the following formula In this example, we have used a formula to put the Excel into degrees mode.

A1- refers to the cell reference with values in radians.įigure 2: How to put Excel into degrees mode using formula.

We can also change excel from radians mode to degrees mode by the use of a formula. In this example, we have converted the radians in column B to degrees in column C with the help of the excel DEGREES function. This is as illustrated in the figure below įigure 1: How to put Excel to Degrees mode using DEGREES function

The first methods to set excel into degrees mode is by the use of the FUNCTION. Let us look at both methods Method 1: Use of the DEGREES function

There are basically two ways to change radians into degrees, so as to have your answer in degrees form. How can you set the Excel to return the answer in degrees instead of radians? This post provides ways on how to put excel in degrees mode. When working with excel spreadsheets, you might want to get the answer in degrees but the Excel is returning it in radians.

How to put excel in degrees mode