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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.