Temperature (degree) symbol

G

Guest

I would like to know the best way (and what to use) for inserting a degree
symbol in front of the C (for Celsius) or F (for Fahrenheit) in an Excel cell.
 
M

MartinW

Hi Shelia,

Hold down the alt key type 0176 on the number pad
and let go the alt key.

HTH
Martin
 
G

Gord Dibben

Create a Custom Format

Type ## then Alt + 0176 then "C"

Note: use the NumPad keys for the 0176............not the number keys above
qwerty


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMULA FOR CELSIUS TO FAHRENHEIT 8
Creating a Formula 4
Convert decimal degree (lattitude/longitude) into Degree, 5
Degree symbol 3
How to determine the closest degree? 2
where can I locate the degree symbol so I can insert it? 1
degree symbol 7
IF Question 4

Top