ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Want to display degrees, minutes, seconds. (0°00'00") (https://www.excelbanter.com/excel-discussion-misc-queries/216768-want-display-degrees-minutes-seconds-0%C2%B00000.html)

kslate

Want to display degrees, minutes, seconds. (0°00'00")
 
I want to use/create a number format that will display the results of the
cell as an angle in degrees, minutes and seconds (0°00'00").

Gary''s Student

Want to display degrees, minutes, seconds. (0°00'00")
 
See:

http://support.microsoft.com/Default.aspx?kbid=213449
and
http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student - gsnu200827


"kslate" wrote:

I want to use/create a number format that will display the results of the
cell as an angle in degrees, minutes and seconds (0°00'00").



All times are GMT +1. The time now is 02:25 AM.

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