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

  • Thread starter Thread starter tenban
  • Start date Start date
T

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!
 
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
 
Back
Top