Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
calculate from degrees to degrees/minutes/seconds on excel? | Excel Worksheet Functions | |||
convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions |