Is there a way to format numbers to show as degrees farenheit?

[tenban]

I am trying to format a list of numbers and have them formated in degrees
farenheit...with the little degree symbol at the end of the number...can this
be done and if so please tell me how?
Many Thanks!
Something so simple, but so frustrating!

 

[Niek Otten]

The degrees-sign is, depending on your font, Char(176) or Char(186)
You need to get that into the Custom format, after a zero.
One way: in a cell, enter =CHAR(176). Copy the cell and paste the symbol
into the Type box of the Format Custom dialog.
Another way to enter the symbol is to keep the Alt-key pressed while type
0176 on the numeric keypad (not on the main keyboard!)
In both cases, use 186 if applicable to your font