ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert an angle to degrees minutes seconds (https://www.excelbanter.com/excel-discussion-misc-queries/18651-convert-angle-degrees-minutes-seconds.html)

Mac

convert an angle to degrees minutes seconds
 
angles are formatted like 90.5 degrees. or 90 degrees 30 mins 00 seconds it
shoult look like this 90* 30' 00" (the * is a degree symbol) i odnt know how
to get excell to do this

JE McGimpsey

See

http://cpearson.com/excel/latlong.htm



In article ,
Mac wrote:

angles are formatted like 90.5 degrees. or 90 degrees 30 mins 00 seconds it
shoult look like this 90* 30' 00" (the * is a degree symbol) i odnt know how
to get excell to do this



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

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