See if Chip's site helps http://www.cpearson.com/excel/latlong.htm

--
HTH

Bob Phillips

"iman1000" wrote in message
...
Positions are often given in lat/lon in deg/min/sec units. Is there a way
to
represent this in Excel (other than a separate cell for each component) -
similar to date/time?