View Single Post
 
Old 04-22-2012, 07:53 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jamal,

You can use a custom number format to display an angle in the ##º##'##'' format. However, this requires dividing an angle expressed in decimal degrees by 24 (eg =30/24 for a 30º angle). The custom number format (which is technically a time format) is:
[hh]ºmm'ss''
or, if you need even greater precision, you could use:
[hh]ºmm'ss.00''
Accordingly, depending on what you're trying to do at a certain point, you can use a formula like the one above or like =A1/24, plus the custom number format. For example, for a chart you might use the actuall values for drawing the angles and the custom formatted ones for the angle labels.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote