| 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 | |||
Linear Mode
