Cell formatting: displaying lat/long coordinates

Nelson · May 10, 2004

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 · May 10, 2004

Take a look at

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

Nelson · May 10, 2004

Take a look at

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

AWESOME!
Many many thanks.

Cell formatting: displaying lat/long coordinates

Nelson

JE McGimpsey

Nelson