Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Degree symbol in Excel 1
- Thread starter pctechguy
- Start date
- Thread starter
- #2
-
1
- #3
1. Select the cells you want to format for temperature.
2. Right-click the selected cells and choose Format Cells from the shortcut menu.
3. Click the Number tab.
4. Under Category, choose Custom.
5. In the Type box, type 0.0, followed by a double-quote ("
.
6. Still in the Type box, hold down the Alt key and type 0176 on the numeric keypad (this inserts the degree symbol).
7. Still in the Type box, type either an F for Fahrenheit or a C for Celsius, followed by another double-quote. Your finished entry in the Type box should look like 0.0"_F" or 0.0"_C".
8. Click OK.
2. Right-click the selected cells and choose Format Cells from the shortcut menu.
3. Click the Number tab.
4. Under Category, choose Custom.
5. In the Type box, type 0.0, followed by a double-quote ("
. 6. Still in the Type box, hold down the Alt key and type 0176 on the numeric keypad (this inserts the degree symbol).
7. Still in the Type box, type either an F for Fahrenheit or a C for Celsius, followed by another double-quote. Your finished entry in the Type box should look like 0.0"_F" or 0.0"_C".
8. Click OK.
SkipVought
Programmer
All ya gotta do is...
in the formula bar
1. highlight the "o" character
2. right click & select Format Cells
3. check the superscript checkbox
98.6[sup]o[/sup]F
Skip,
Skip@TheOfficeExperts.com
in the formula bar
1. highlight the "o" character
2. right click & select Format Cells
3. check the superscript checkbox
98.6[sup]o[/sup]F
Skip,
Skip@TheOfficeExperts.com
- Status
