Can I format a cell to display latitude and longitude
 

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

Can I format a cell to display latitude and longitude
 

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

Can I format a cell to display latitude and longitude
 

I've tried the methods mentioned on that webpage but they don't work. All
they display is zeros; not the numbers I am typing in.

Thanks for trying

"Niek Otten" wrote:

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

Can I format a cell to display latitude and longitude
 

http://www.cpearson.com/excel/latlong.htm
--
David Biddulph

"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