NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
At signs, degrees, and text colors
From: Andrew Nikitin
Date: 2013 May 21, 05:47 -0700
From: Andrew Nikitin
Date: 2013 May 21, 05:47 -0700
> Anyone know a way to place the degree symbol in Excel (non commercial)
> without an extended keyad/numlock key?
I use autocorrect feature. In E2010 it is under File|Options|Proofing|AutoCorrect Options (older versions also have it but in different place)
In "Replace" field put "^o" and in "With" field put degree sign.
Then when you type 20^o it turns it into 20°
----------------------------------------------------------------
NavList message boards and member settings: www.fer3.com/NavList
Members may optionally receive posts by email.
To cancel email delivery, send a message to NoMail[at]fer3.com
----------------------------------------------------------------