How do I represent values in Degrees Minutes Seconds in Excel?

[Topcon Ben]

I need to format the results of a =DEGREES(ATAN(x)) formula to be in Degrees
Minutes Seconds format. I don't want to have to do decimal degrees, not put
the results in 3 different columns (which I have done in the past).

 

[Gary''s Student]

See:

http://support.microsoft.com/?kbid=213449

So if A1 contains:
0.2
and B1 contains:
=DEGREES(ATAN(A1)) (displaying 11.30993247)
then another cell containing:
=convert_degree(B1) will display 11° 18' 36"

 

[Topcon Ben]

Thanks for your help. That's awesome. What a time saver this will be.