How do I set up a custom number format that includes a degree symbol?

By barnett ·
I'm trying to set up a custom number format that includes a degree symbol. I can append it to a number in an individual cell using Alt-00B0, but have not been able to make that work in the custom number format setup, so I can use it in a group of cells. The format painter won't even copy it to other cells.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Not sure if this is what you're looking for, but...

by CaptBilly1Eye In reply to How do I set up a custom ...

... when using Excel, here's how to format a group of cells to automatically add a degree symbol (&deg to the end of a number.

1. Select (highlight) the column(s) and/or row(s) that you want to include.
2. Go to the Format menu and select Cells.
3. On the Number tab, scroll down on the left to Custom.
4. In the right hand 'Type' field, input the number of numeric characters to be included using pound symbols (ex. #### for up to four numbers)
5. Use <b>ALT + 0176</b> to add the degree symbol to the end (ex. ####&deg.
6. Click OK.
<b>Note</b> You must use the numeric keypad to type the numbers and not the keyboard. Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad.

This will add a degree symbol to the end of all numbers currently in those cells and any future ones added.

Here is an article that may provide additional ideas:

I found this utility that would add new number formatting functionality in Excel including adding a degree symbol: ConnectCode

I hope this helps.

Collapse -

Thanks, that did the trick!

by barnett In reply to Not sure if this is what ...

I had followed your procedure earlier and couldn't get it to work, but the degree symbol I found was in the Unicode (hex) section at 00B0, and the custom format setup wouldn't accept that. Alt-0176 in the ASCII (decimal) section is where I should have looked, but didn't think of checking that. Lesson learned. Many thanks for your quick response.

I'll also check out the links you mentioned.


Collapse -

Glad I could help...

by CaptBilly1Eye In reply to Thanks, that did the tric ...

It is greatly appreciated if you tag all useful responses as 'Helpful' by opening those posts and clicking the 'Mark Helpful' button at the bottom. That way, people with a similar situation in the future will be able to quickly see what ultimately helped. Thanks.


Related Discussions

Related Forums