K
Karl
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
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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,
Lungmus
0186 on the number keypad,
Ifyou dont want the decimal places to display go ### Alt 0186
Regards,
cell. I want to show like 98 with the degree symbol behind it. Thanks KarlKarl said:Hi I would like to know where to find and how to use the degre ymbol in a
Lungmus
D
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.
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.
D
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
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
M
mansure
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
you'll find the symbol, insert the symbol into cell and then type the number
98.
good luck
G
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
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
B
Bernard Liengme
I think the quote has slipped; should be ###.0 "(ALT + 0176)F"
best wishes
Bernard
best wishes
Bernard
G
Gord Dibben
Bernard
The (ALT + 0176) is not typed in. Just a manual keying operation.
Gord
The (ALT + 0176) is not typed in. Just a manual keying operation.
Gord