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?