Question Locked

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

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

4 replies

by captbilly1eye

... when using Excel, here's how to format a group of cells to automatically add a degree symbol (°) 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 ALT + 0176 to add the degree symbol to the end (ex. ####°).
6. Click OK.
Note 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: http://office.microsoft.com/en-us/help/HA011179441033.aspx

I found this utility that would add new number formatting functionality in Excel including adding a degree symbol: ConnectCode http://www.spreadsheetml.com/numbermanager.html

I hope this helps.

by barnett

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.

Herb

by captbilly1eye

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.

:-)

This discussion is closed to new replies.