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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Blair" wrote in message ...
|I am trying to show Latitude and Longitude in my spreadsheet. Is there a way
| to format a cell to display D° MM' SS.SSS, and then have it display that in
| the spreadsheet