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

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ps.com...
I regularly use Latitude and Longitude in all three formats, and though
I have looked through the topics here, I cannot find one that deals
with a formula to convert from one form to the other two.

For instance, I have the DD MM.DEC format, and I would like to convert
it to both DD MM SS and DD.DEC formats. Is there anyone that has dealt
with this before?

Thank you, Kit Nickel