Degrees, Minutes and Seconds

[Yosof Ewing]

Hey Guys

Does anybody know how to convert an angle in degrees into
degrees, minutes and seconds? ( o ' " ).

Yosof

 

[Frank Isaacs]

XL2000: Function to Convert Degrees/Minutes/Seconds Angles to or from
Decimal Angles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213449

Custom Function to Express Degree to/from as Fractions of Degrees:
http://support.microsoft.com/default.aspx?scid=kb;en-us;121944

--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com

 

[Ron Rosenfeld]

Hey Guys

Does anybody know how to convert an angle in degrees into
degrees, minutes and seconds? ( o ' " ).

Yosof

Well, you can't display it that way as other than a text string. If that's OK,
then with the angle in degrees in B1:


=TEXT(INT(B1),"0\° ")&
TEXT(INT(MOD(B1,1)*60),"0\' ")&
TEXT(MOD(MOD(B1,1)*60,1)*60,"00.0\""")


--ron