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