Cellwise Start free

Excel guide · 6 min read

How to insert the degree symbol in Excel

Quick answerDouble-click the cell, hold Alt and type 0176 on the number pad, then release Alt: a ° appears. Without a number pad, use Insert > Symbol, choose Latin-1 Supplement in the Subset box, pick the degree sign and click Insert. On a Mac with a US keyboard, press Option+Shift+8. For a column of temperatures, use a custom number format such as 0"°F" instead, so the cells stay numbers you can average and chart.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDE
1CityHigh (°F)High (°C)ImportedBack to a number
2Phoenix10440104°F104
3Miami8931.789°F89
4Chicago7423.374°F74
5Seattle6618.966°F66
6Denver8127.281°F81
7Boston7021.170°F70
8Anchorage5814.458ºF#VALUE!

Which method to pick

It depends on whether the ° is a label or sits next to numbers you'll calculate with:

  • A heading or a note, such as High (°F): type it with Alt+0176, Insert > Symbol or Option+Shift+8.
  • A column of temperatures or angles: use a custom number format. The cell shows 104°F but holds 104.
  • A label built by a formula for a chart title or a sentence: join it with &"°F", knowing the result is text.
  • Data that arrived with the symbol typed in: strip it with SUBSTITUTE to get numbers back.

Method 1: Alt+0176 on Windows

This is the fastest way on a keyboard with a number pad. The digits must come from the number pad with Num Lock on; the number row above the letters won't work. Alt+248 on the number pad gives the same ° on most Windows setups, if that's easier to remember.

  1. Double-click the cell, or select it and press F2, so the cursor is inside the text.
  2. Hold Alt and type 0176 on the number pad.
  3. Release Alt. The ° appears where the cursor was.
  4. Type the rest, such as F or C, and press Enter.

What if my laptop has no number pad?

Use Insert > Symbol (Method 2), or press Windows key + period to open the emoji panel, which has a symbols section. Some laptops also have a hidden number pad behind an Fn key, but layouts vary.

Method 2: Insert > Symbol

The Symbol dialog works on any Windows keyboard. Once you've used the degree sign, it sits in the Recently used symbols row, so the second time is one click.

  1. Select the cell, or double-click into it where the ° should go.
  2. Go to Insert > Symbol (in the Symbols group).
  3. Leave the Font on (normal text) and choose Latin-1 Supplement in the Subset box.
  4. Click the degree sign. Its character code, 00B0, shows at the bottom with from: Unicode (hex). You can also type 00B0 into the Character code box to jump straight to it.
  5. Click Insert, then Close.

How do I type a degree symbol on a Mac?

Option+Shift+8 on the US keyboard layout. Other layouts differ; Insert > Symbol in Excel for Mac opens the Character Viewer, where you can search for "degree".

Can I make Excel type ° for me?

Yes, with an AutoCorrect entry. Go to File > Options > Proofing > AutoCorrect Options, type a code you'd never use as a word in Replace, such as (deg), paste ° into With, and click Add. AutoCorrect entries are shared with other Office apps.

Method 3: a number format that keeps temperatures numeric

If you type 104°F into a cell, Excel stores the text "104°F". AVERAGE skips it, charts can't plot it, and sorting puts 58°F after 104°F because text sorts character by character. A custom number format avoids all that: the cell holds 104 and only the display adds °F.

  1. Select the temperatures, for example B2:B8.
  2. Press Ctrl+1 and go to the Number tab.
  3. Choose Custom and type 0"°F" in the Type box. Use 0.0"°C" for one decimal place, or 0"°" for angles.
  4. Click OK. The cells show 104°F and so on, and any formula still sees 104.

How can I check the format before applying it?

TEXT uses the same format codes, so it shows exactly what the cell will display.

=TEXT(B2,"0""°F""")

Result: 104°F

104°F: the format code with the quotation marks doubled inside the formula. In the Format Cells box you type it with single quotation marks: 0"°F".

Can I do this in Excel for the web?

Microsoft says custom number formats can't be created in Excel for the web. Add the format in the desktop app; it then displays in the browser too.

Method 4: join the symbol with a formula

For a chart title, a dashboard label or a sentence, joining is fine. In the sample, =B2&"°F" returns 104°F. Paste the ° into the formula, or on Windows use CHAR(176), which returns the same character there. Mac Excel uses a different character set for CHAR, so the pasted ° is the safer choice in a shared file.

Just don't use a joined column as your data. The result is text, so it can't be averaged or charted.

=ISNUMBER(B2&"°F")

Result: FALSE

FALSE: the joined value is text, not a number. ISNUMBER(B2) on the original is TRUE.

Convert °F to °C (and back)

Keep the readings as numbers and the conversion is one formula. Column C of the sample does this for every city, rounded to one decimal place. Going the other way, °F = °C × 9/5 + 32.

=ROUND((B2-32)*5/9,1)

Result: 40

40: Phoenix's 104°F is 40°C. Filled down, Chicago's 74°F becomes 23.3°C and Anchorage's 58°F becomes 14.4°C.

Does the format change when I convert?

No, number formats aren't converted. Give column C its own format, 0.0"°C", or it will still say °F if you copied the format across.

Turn typed degrees back into numbers, and the look-alike that breaks it

Column D holds readings that came from a web page with the symbol typed in. SUBSTITUTE removes the °F and VALUE turns what's left into a number.

=VALUE(SUBSTITUTE(D2,"°F",""))

Result: 104

104: a real number again, ready to average or chart. For a one-off clean-up you can also select the column, press Ctrl+H, find °F and replace with nothing.

Why does one row give #VALUE!?

Look closely at D8: 58ºF. That's º, the masculine ordinal indicator used in Spanish and Portuguese (1º), not the degree sign. It's smaller and underlined in some fonts, and it often arrives from those keyboard layouts or copied text. SUBSTITUTE doesn't find "°F", so VALUE is left with text.

=VALUE(SUBSTITUTE(D8,"°F",""))

Result: #VALUE!

#VALUE!: the ordinal º was not replaced, so 58ºF can't become a number.

How do I fix both characters at once?

Swap the look-alike for the real degree sign first, then remove it.

=VALUE(SUBSTITUTE(SUBSTITUTE(D8,"º","°"),"°F",""))

Result: 58

58: the inner SUBSTITUTE turns º into °, the outer one removes °F. Use this version for the whole column.

Common mistakes

Typing 104°F into data cells

That stores text that won't average or chart. Type 104 and use the custom format 0"°F".

Pressing Alt+0176 with the number row

Alt codes need the number pad with Num Lock on. Use Insert > Symbol on a laptop.

Using º (ordinal) instead of ° (degree)

They look alike but are different characters, so searches and SUBSTITUTE miss them. Replace º with ° first.

Copying a °F format onto converted °C values

Give each column its own format. The format is only a label and doesn't convert anything.

FAQ

What is the shortcut for the degree symbol in Excel?

Alt+0176 on the number pad in Windows, or Option+Shift+8 on a Mac with a US keyboard. There's no ribbon button for it.

How do I add a degree symbol to a whole column in Excel?

Select the column, press Ctrl+1, choose Custom and type 0"°F" or 0"°". Every number shows the symbol and stays a number.

How do I type degrees Celsius in Excel?

Type ° with Alt+0176 and then a capital C. For numbers, use the custom format 0.0"°C" so the values still calculate.

What is the character code for the degree symbol?

00B0 in Unicode (hex), which is what Insert > Symbol shows. On Windows, CHAR(176) returns it in a formula.

Why does my degree symbol look different in another file?

It may be the ordinal º or a ring accent rather than the degree sign. Re-insert it with Alt+0176 or Insert > Symbol to be sure.

Functions used

Related guides

Updated