[Shelia]

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.

[MartinW]

Hi Shelia,

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

HTH
Martin


"Shelia" wrote in message
...
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.

[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

On Wed, 25 Jul 2007 05:20:02 -0700, Shelia
wrote:

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.