Cell formatting: displaying lat/long coordinates

[Nelson]

Rather than formatting a cell to display time in hours and minutes and seconds, I would like to display latitude and longitude in degrees, minutes, and seconds.
e.g. 43º 25' 34"

Is this possible in Excel 2000?

 

[JE McGimpsey]

Take a look at

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

 

[Nelson]

Take a look at

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

AWESOME!
Many many thanks.