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
