Degree sign

  • Thread starter Thread starter Tim Schaefer
  • Start date Start date
T

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.
 
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
 
Biff said:
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
Click to expand...

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

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
 
Chip Pearson said:
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
Click to expand...

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

Jim.
 
Back
Top