degree symbol

[Guest]

Hi I would like to know where to find and how to use the degre ymbol in a cell. I want to show like 98 with the degree symbol behind it. Thanks Karl Lungmus

 

[Alan]

Go Format Cells > Custom. Enter ###.0 then hold down the Alt key and type
0186 on the number keypad,
Ifyou dont want the decimal places to display go ### Alt 0186
Regards,

Hi I would like to know where to find and how to use the degre ymbol in a

cell. I want to show like 98 with the degree symbol behind it. Thanks Karl
Lungmus

 

[Debra Dalgleish]

You can format the cell to display a degree symbol with the number. This
will allow the numbers to be used in calculations:

Select the cells in which you will type the numbers
Choose Format>Cells
On the Number tab, choose Custom
In the text box, type: General
Then hold the Alt key, and on the number keypad, type 0176
Release the Alt key, and the degree symbol will appear.
General°
Click OK

If you want to use the symbol in a cell, and don't need the number to be
used in calculations, you can use Alt+0176 to add the symbol in the cell.

 

[David McRitchie]

Hi Alan,
ALT+0186 or CHAR(186) is actually a superscript zero.
ALT+0176 or CHAR(176) is the degree symbol.
In HTML the token is °

In Excel if you want a custom number format you can use
0°"F"

If you were interested in Latitude and Longtitude, see Chip Pearson's
http://www.cpearson.com/excel/latlong.htm

You can see a chart at
Symbols for HTML and Excel use
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Guest]

choose insert/symbol and then choose font:normal text, subset: latin-1, there
you'll find the symbol, insert the symbol into cell and then type the number
98.
good luck

 

[Gord Dibben]

Karl

If you need the temperatures in number form for calcultions you will have to
add a Custom Format rather than in-cell editing.

Format>Cells>Custom. Select the 0 format and click in dialog box to edit.

###.0(ALT + 0176)"F"

Steps...enter the ###.0 then on Numpad(gray keys) enter ALT + 0176 then add
the "F" or "C" and you're done.

Gord Dibben Excel MVP

 

[Bernard Liengme]

I think the quote has slipped; should be ###.0 "(ALT + 0176)F"

best wishes

Bernard

 

[Gord Dibben]

Bernard

The (ALT + 0176) is not typed in. Just a manual keying operation.

Gord