ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Degree, Minutes, Seconds (https://www.excelbanter.com/excel-discussion-misc-queries/52890-degree-minutes-seconds.html)

AlanT

Degree, Minutes, Seconds
 
Does excel accept numbers in degree, minutes, seconds format for angles or
does it only accept degrees and radians? If it does, what is the correct way
to do it and is there a conversion I can use to convert it to just regular
degree format? Thanks.

AlanT

Degree, Minutes, Seconds
 
Sorry, didn't look hard enough, found the webpage for it.
http://support.microsoft.com/?kbid=213449

Chip Pearson

Degree, Minutes, Seconds
 
All of Excel's trig functions work only with radians, not
degrees. If you have degrees, convert them to radians with the
RADIANS function. When working with degrees, minutes, and
seconds, treat them as times.


"AlanT" wrote in message
...
Does excel accept numbers in degree, minutes, seconds format
for angles or
does it only accept degrees and radians? If it does, what is
the correct way
to do it and is there a conversion I can use to convert it to
just regular
degree format? Thanks.





All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com