How To Do Degrees In Excel: Simple Formatting For Angle Data

I spent years manually converting radians to degrees in Excel before discovering the DEGREES function. It’s shockingly simple: type =DEGREES(angle) and Excel does the heavy lifting for you.

This works for single cells or entire columns of data. I’ve used it for everything from trigonometry homework to engineering calculations. No special tools or add-ons required—just Excel’s built-in functions.

You’ll get precise angle conversions every time, with results formatted exactly how you need them. It’s the kind of tool that makes you wonder why you didn’t learn it sooner.

Works in Excel 2013 and newer, including 365. Here’s how to set it up in under 60 seconds.

What Youll Need

Instructions

Here is the procedure I use to format and calculate with angle data in spreadsheets.

Type your angle measurements directly into the cells as plain numbers. Excel stores all numbers internally as values, so entering 45 or 30.5 is sufficient for the degree value itself. Avoid including the degree symbol at this stage—it will cause Excel to treat the entry as text instead of a number.

If you already have data with the degree symbol (°), use Find and Replace to remove it. Press Ctrl+H, enter ° in the “Find what” field, leave “Replace with” blank, then click Replace All. This converts all entries to numeric values.

Select the cells containing your angle data. Right-click and choose Format Cells, or press Ctrl+1. In the Format Cells dialog, go to the Number tab and select Custom from the category list.

In the Type field, enter 0° for whole degrees, 0.0° for one decimal place, or 0.00° for two decimal places. Click OK. The degree symbol now appears after each value, but Excel still treats the underlying data as a number for calculations.

Many trigonometric functions in Excel expect angles in radians. To convert degrees to radians, use the RADIANS function. In a new cell, enter =RADIANS(A1), where A1 contains your degree value. This returns the equivalent angle in radians.

For the reverse conversion from radians back to degrees, use the DEGREES function: =DEGREES(A1). This is particularly useful when working with results from functions like ASIN, ACOS, or ATAN, which return radians by default.

With your angles properly formatted, use standard trigonometric functions. For example, to find the sine of an angle in A1 (already in degrees), use =SIN(RADIANS(A1)). Similarly, use =COS(RADIANS(A1)) or =TAN(RADIANS(A1)) for cosine and tangent.

For inverse trigonometric functions, which return radians, wrap the result in the DEGREES function: =DEGREES(ASIN(0.5)) returns 30°. This ensures your results display in the correct unit without manual conversion.

Check your work by testing known values. For instance, =SIN(RADIANS(90)) should return 1, and =DEGREES(ACOS(0.5)) should return 60. If results seem off, double-check that your angle values are numeric and not text.

Use the ISTEXT function to verify: =ISTEXT(A1) should return FALSE for properly formatted angle cells. If it returns TRUE, remove any non-numeric characters and reapply the custom formatting.

Tips and Common Mistakes

Small oversights can derail your angle calculations, but these adjustments keep everything precise.

Data Entry Precision: In Step 1, always enter angles as plain numbers without the degree symbol. I learned this the hard way after Excel kept treating my entries as text. Even a stray space before the number can cause issues—clean your data first.

Formatting Clarity: For Step 2, remember that 0.0° gives one decimal place while 0.00° gives two. This distinction matters when working with precise engineering calculations. The underlying data remains numeric regardless of how many decimals you display.

Function Nesting: In Step 3 and 4, always wrap your trigonometric functions properly. For example, =SIN(RADIANS(A1)) converts and calculates in one step. Forgetting the RADIANS function will give incorrect results since Excel’s trig functions expect radians by default.

Validation Shortcut: Step 5’s verification becomes much easier when you use =ISTEXT(A1) to confirm your values are numeric. If this returns TRUE, you’ll need to remove any non-numeric characters before reapplying your custom formatting.

Frequently Asked Questions

Now you know how to display and work with degree symbols in Excel! ✨ Whether formatting angles or performing calculations, these simple steps ensure accuracy and clarity. Ready to put your new skills to the test? Try applying them to your next project or dataset!