degrees
Im trying to get a decimal degree to show up in a cell as
deg°-min'-sec." or enterin the degree as deg-min sec and getting a dec. degree an6y body have any suggestions? |
Jarhead, hold down the ALT key and enter the value 248 on the numeric
keypad. When you release the Alt key, you will see the degree symbol appear. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jarhead for life" <Jarhead for wrote in message ... Im trying to get a decimal degree to show up in a cell as deg°-min'-sec." or enterin the degree as deg-min sec and getting a dec. degree an6y body have any suggestions? |
http://www.cpearson.com/excel/latlong.htm
Regards, Peo Sjoblom "Jarhead for life" wrote: Im trying to get a decimal degree to show up in a cell as deg°-min'-sec." or enterin the degree as deg-min sec and getting a dec. degree an6y body have any suggestions? |
still having problems when i used the custom format hh°mm'ss\"
it returns a completely differnet number? ex. I typed 45° 29' 34.12" and excel returns 21°29'34" how do i fix this ? "Peo Sjoblom" wrote: http://www.cpearson.com/excel/latlong.htm Regards, Peo Sjoblom "Jarhead for life" wrote: Im trying to get a decimal degree to show up in a cell as deg°-min'-sec." or enterin the degree as deg-min sec and getting a dec. degree an6y body have any suggestions? |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com