ExcelBanter - How do I enter/format latitude and longitude coordinates in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I enter/format latitude and longitude coordinates in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/70849-how-do-i-enter-format-latitude-longitude-coordinates-excel.html)

Servant_

How do I enter/format latitude and longitude coordinates in Excel

I need to enter geographic data in excel. Is there a formating category for
latitude and longitude, and will it convert between different degree,
minutes, seconds formats?

Niek Otten

How do I enter/format latitude and longitude coordinates in Excel

See

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

--
Kind regards,

Niek Otten

"Servant_" wrote in message
...
I need to enter geographic data in excel. Is there a formating category
for
latitude and longitude, and will it convert between different degree,
minutes, seconds formats?

All times are GMT +1. The time now is 05:51 AM.