degrees

[Guest]

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?

 

[Paul B]

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

 

[Guest]

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

Regards,

Peo Sjoblom

 

[Guest]

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 ?