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

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).

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

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"
--
Gary''s Student - gsnu200771


"Topcon Ben" wrote:

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).

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

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

"Gary''s Student" wrote:

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"
--
Gary''s Student - gsnu200771


"Topcon Ben" wrote:

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).