how do I format a cell to display in degrees minutes seconds

[Guest]

i am trying to format a cell so that when I type in the strand of numbers, it
will display in degrees minutes seconds. Then I also need to know how to
convert it to decimal degrees.

 

[Niek Otten]

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

--
Kind regards,

Niek Otten

|i am trying to format a cell so that when I type in the strand of numbers, it
| will display in degrees minutes seconds. Then I also need to know how to
| convert it to decimal degrees.