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]
|