Excel
 

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

If you have Excel 2003 or newer you can insert-symbol and select the symbol

"Susan" wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

Also, after you have done that you can set it up to work automatically, place
the degree symbol alone in an empty cell. Copy that cell and in the menu go
to Tools-Auto-Correct Options and insert someting you want to convert (I use
(*)) then paste the degree symbol into the with box and hit add. Now when you
type (*) you will get the degree symbol.

-John

"Susan" wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

Try this:

When editing a cell....

Hold down the [alt] key....type 0176...release the [alt] key

There's your degree symbol: °

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Susan" wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

ALT + 0186(using numpad)

If you have a list of numbers to add the degree symbol to, select the data then
FormatCellsNumberCustom

Clear the dialog box then ALT + 0186

All numbers will have the degree symbol.


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 11:34:00 -0800, Susan
wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

[alt]+0186 seems to return a BIGGER degree symbol than [alt]+0176

So, I looked them up.

According the the symbol dialog....
[alt]+0176 is the "degree symbol"

[alt]+0186 is the "MASCULINE ORDINAL INDICATOR", whatever that is.

Who names those things?

***********
Regards,
Ron

XL2002, WinXP


"Gord Dibben" wrote:

ALT + 0186(using numpad)

If you have a list of numbers to add the degree symbol to, select the data then
FormatCellsNumberCustom

Clear the dialog box then ALT + 0186

All numbers will have the degree symbol.


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 11:34:00 -0800, Susan
wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!

Excel
 

Ron

Never noticed the difference before you brought it up.

I have a little macro that adds the Chr(186) to numbers and don't know if I ever
tried the 176

Also have a couple macros that add m³ and m² to numbers.

I don't know who names these things, but probably has a Latin origin.


Gord

On Wed, 6 Dec 2006 13:50:01 -0800, Ron Coderre
wrote:

[alt]+0186 seems to return a BIGGER degree symbol than [alt]+0176

So, I looked them up.

According the the symbol dialog....
[alt]+0176 is the "degree symbol"

[alt]+0186 is the "MASCULINE ORDINAL INDICATOR", whatever that is.

Who names those things?

***********
Regards,
Ron

XL2002, WinXP


"Gord Dibben" wrote:

ALT + 0186(using numpad)

If you have a list of numbers to add the degree symbol to, select the data then
FormatCellsNumberCustom

Clear the dialog box then ALT + 0186

All numbers will have the degree symbol.


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 11:34:00 -0800, Susan
wrote:

Can anyone tell me the keystroke(s) to make a degree symbol? Thank YOU!



Gord Dibben MS Excel MVP