Degree Symbol in Excel: Add It to a Cell and Format Values

How-to basics · Updated November 22, 2026

To show a degree symbol in an Excel cell, type it with the Windows numeric-keypad shortcut Alt+0176, or enter =UNICHAR(176) in a cell. If the cell contains a number you still need to calculate with, apply a custom number format such as 0"°" instead; it displays the symbol while keeping the value numeric.

Quick ways to enter the degree symbol

The degree symbol is °, Unicode character U+00B0. In Excel for Microsoft 365 on Windows, you can insert it directly into a cell or formula in several ways. Choose the method based on whether you want a one-off text entry, a reusable formula result, or a numeric value with a display suffix.

  • Windows keyboard: Select a cell, hold Alt, type 0176 on the numeric keypad, then release Alt. Num Lock may need to be on. The number row above the letters usually does not work for this Alt code.
  • Copy and paste: Copy this character, °, and paste it into a cell, a formula, or a number format.
  • Excel formula: Enter =UNICHAR(176) to return the symbol. The cell layout for this example is simply an empty destination cell in which you enter the formula; its result is °.
  • Ribbon: Choose Insert > Symbol, select the degree symbol in the dialog, and choose Insert.

For a quick label such as “High: 30°,” direct typing or pasting is usually simplest. For a column of calculated readings, a formula or number format is more consistent. The key distinction is whether Excel should treat the result as text or preserve it as a number.

What the symbol means and what it is not

The degree sign is a small circle used with measurements such as angles and temperature scales. It is not the same character as the masculine ordinal indicator, º, which can look similar at small sizes. If a pasted symbol looks wrong or does not match other entries, check that it is ° rather than º. The formula =UNICHAR(176) returns the degree sign, not the ordinal character.

For temperature, the scale letter matters: °C means degrees Celsius and °F means degrees Fahrenheit. A lone degree sign does not say which scale is intended. For angles, a value such as 90° commonly indicates a quarter-turn. Add the appropriate letter or other context when a reader could mistake the measurement.

Use a formula to add the symbol

UNICHAR returns the character associated with a Unicode number. Since the degree symbol is character 176, the formula can produce it by itself or join it to text or a cell value. This is useful when labels are generated from changing data, although concatenating a number and a symbol creates text rather than a numeric measurement.

With the measured number in A2—for example, 25—and an empty result cell, enter =A2&UNICHAR(176). The result is 25°. If A2 changes, the displayed text updates. Because the result is text, you should generally do calculations on A2, not on the concatenated result.

With a temperature number in A2—for example, 25—and an empty result cell, enter =A2&" "&UNICHAR(176)&"C". The result is 25 °C. The spaces and C are ordinary text added by the formula. Change the final C to F when the value is Fahrenheit, and make sure the label matches the data rather than merely changing the appearance.

If the symbol is needed in several formulas, UNICHAR avoids having to enter or paste the character each time. It is available in modern Excel, including Microsoft 365. A formula result is recalculated when its referenced cells change, but formulas that return text may not behave like numbers in sorting, charting, or other calculations.

Show a suffix without changing the numeric value

For measurements you will sum, average, chart, or convert, a custom number format is usually the best choice. It changes how a value appears, not the value stored in the cell. A cell containing 23.5 remains the number 23.5 even when Excel displays it as 23.5°.

  1. Select the numeric cells.
  2. Press Ctrl+1 on Windows to open Format Cells.
  3. On the Number tab, choose Custom.
  4. In the Type box, enter 0"°" for whole numbers, or 0.0"°" for one decimal place.
  5. Choose OK. The selected values display with a degree sign.

For Celsius readings, a useful format is 0.0" °C"; for Fahrenheit, use 0.0" °F". The quoted text is a literal suffix. The format controls the number of displayed decimal places but does not round or replace the underlying value. For example, a value stored as 23.56 can display as 23.6 °C while calculations still use 23.56.

Custom formats can include separate patterns for positive, negative, and zero values, separated by semicolons. That is more than most basic temperature columns need, but it can help when you want negative values shown with a minus sign and zero shown as a dash. Be deliberate: formatting zero as a dash changes only its appearance, which may confuse someone reading a report.

Insert the symbol with Excel’s menus

If you do not have a numeric keypad or prefer not to memorize a shortcut, use Excel’s symbol dialog. Select the destination cell, choose Insert > Symbol, locate the degree symbol in the dialog, and select Insert. Depending on the dialog’s current font and character set, you may need to choose a suitable font or browse the character list. Close the dialog when finished.

This inserts the character as text at the cell’s insertion point. To add it after existing text, edit the cell first by double-clicking it or pressing F2, move the insertion point to the end, and then insert the character. If you select a cell and insert the symbol without entering edit mode, Excel may place it in the cell as its entire contents, replacing what was there. Check the cell before continuing.

You can also put the degree character in a formula by copying it from another location, but UNICHAR is often easier to read and reuse. When typing a literal symbol into a formula, make sure it is enclosed in quotation marks as text. For a numeric value with a recurring suffix, however, a custom number format avoids converting numbers into text.

Choose the right method for your worksheet

The right approach depends on what the cell represents and what people need to do with it. A report label, a temperature log, and an angle calculation may all show the same symbol but have different data requirements.

  • One-off note or heading: Type, paste, or insert ° directly. The cell is text, which is appropriate for a label.
  • Automatically built label: Use UNICHAR in a formula, optionally joined to a value. Remember that the result is text.
  • Temperature or angle data used in calculations: Keep the number in the cell and apply a custom number format. This preserves numeric behavior.
  • Data that will be exported: Check what the receiving system expects. A number with a display-only format may export as a plain number, while a formula-generated label exports as text.

For a clean data table, another strong design is to keep the measurement in one column and the unit in a separate heading or unit column. That makes values easier to filter and compare, especially if the worksheet contains mixed units. If each row has its own unit, keep the unit explicit rather than relying on a column title that could be lost when data is copied elsewhere.

Windows, Mac, and Excel for the web

The Alt+0176 instruction above is for Windows with a numeric keypad. On a Mac, the commonly used system shortcut for ° is Option+Shift+8; keyboard layouts can affect character shortcuts, so use Insert > Symbol or copy and paste if it does not produce the expected character. Excel for Mac also supports formulas such as UNICHAR. The Format Cells shortcut differs: use Command+1 on Mac rather than Ctrl+1 on Windows.

In Excel for the web, a dependable option is to type or paste the symbol, or enter a formula such as UNICHAR in a cell. The Windows Alt code depends on a desktop keyboard and is not a reliable browser-based method. If you need a custom number format in the web version, check the available number-format controls in your current Excel interface; desktop Excel provides the full Format Cells dialog described above.

Common problems and fixes

  • Alt+0176 types digits or does nothing: Use the numeric keypad, check Num Lock, and hold Alt while entering the digits. On a laptop without a dedicated keypad, use the symbol dialog, paste °, or use UNICHAR.
  • The value stops calculating: If you joined the number to the symbol with a formula or typed both as text, the result is text. Apply a custom number format to the original numeric value instead.
  • The symbol appears as a box: The selected font may not contain the character, or the receiving application may not support it. Try a common font and confirm the cell contains °, not a similar-looking character.
  • Excel shows too many or too few decimals: Adjust the custom format, such as changing 0"°" to 0.0"°". This changes displayed precision, not the stored measurement.
  • The number format seems to have no effect: Confirm the cell contains a number rather than text that looks like a number. Number formats do not convert text into numeric data.

A related misconception is that adding a degree sign automatically converts a value or identifies its temperature scale. It does neither. The symbol is a character or display suffix; any conversion between Celsius and Fahrenheit must be performed separately, and the scale should be stated clearly.

Frequently Asked Questions

What is the keyboard shortcut for the degree symbol in Excel?
On Windows, hold Alt and type 0176 on the numeric keypad, then release Alt. On Mac, Option+Shift+8 commonly enters °, though the shortcut can vary with keyboard layout.

How do I add a degree symbol after a number without turning it into text?
Keep the cell numeric and use Format Cells > Number > Custom. Enter a format such as 0"°" for whole numbers or 0.0"°" for one decimal place.

Can I use a formula to display the degree symbol?
Yes. Enter =UNICHAR(176) for the symbol alone, or join UNICHAR(176) to a cell value. Joining it to a number returns text, so use custom formatting if you still need a numeric cell.

How do I type °C or °F in Excel?
Enter or paste the degree sign followed by C or F in a text label. For numeric measurements, use a custom format such as 0.0" °C" or 0.0" °F" so the value remains numeric.

Why does Excel show a degree sign but calculations do not work?
The symbol may have been joined to the number as text, or the original entry may have been typed as text. Use a numeric value with a custom number format, and verify that the cell is recognized as a number before applying the format.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.