Degree sign

[Tim Schaefer]

Anyone know how to insert a degree sign into a cell? I
want to display a bearing as N 53 degrees 12'43" E. Word
allows one to insert a degree sign but I don't see how to
do it in XL2000.

 

[Biff]

Hi Tim,

Use this code:

ALT 0176

Hold down the ALT key and use the *numeric keypad* and
type 0176. Release the ALT key and there it is.

Biff

 

[James Silverton]

Hi Tim,

Use this code:

ALT 0176

Hold down the ALT key and use the *numeric keypad* and
type 0176. Release the ALT key and there it is.

Biff

Very true but doesn't Insert...Symbol exist in Excel?

 

[Chip Pearson]

Very true but doesn't Insert...Symbol exist in Excel?

It was added in, I think, Excel 2002. Earlier versions didn't
have Insert Symbol.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[James Silverton]

It was added in, I think, Excel 2002. Earlier versions didn't
have Insert Symbol.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I stand corrected (g)! I don't buy every upgrade and went directly from
Office 95 to Office XP.

Jim.