degrees minutes and seconds
 

how can i make an angle in decimal show as an angle in degrees minuts
and seconds?


--
grandfilth
------------------------------------------------------------------------
grandfilth's Profile: http://www.excelforum.com/member.php...o&userid=28240
View this thread: http://www.excelforum.com/showthread...hreadid=486654

degrees minutes and seconds
 

On Sun, 20 Nov 2005 08:36:14 -0600, grandfilth
wrote:


how can i make an angle in decimal show as an angle in degrees minuts
and seconds?

A1: Decimal Angle
B1: =A1/24
Format/Cells/Number/Custom Type:
[h]° mm' ss\"

(The "degree" sign is entered by holding down the <alt key and typing 0176 on
the numeric keypad).

This takes advantage of the fact that there is the same relationship between
degrees/minutes/seconds as there is between hours/minutes/seconds and uses
Excel's built in time format.


--ron