ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Navigation Questions (https://www.excelbanter.com/new-users-excel/259271-navigation-questions.html)

trvlnmny

Navigation Questions
 
I am using W XP & Excel 2003.
I am entering latitudes and longitudes into a workbook. What I would
like to know is whether Excel can compute the distance between any 2
locations? Also can Excel convert a coordinate in latitude and
longitude format into a coordinate in UTM format?
Thanks for the help.

JLatham

Navigation Questions
 
It looks like Chip Pearson was just waiting for you to come along and ask
those very questions. See:
http://www.cpearson.com/EXCEL/LatLong.aspx

Good luck.

"trvlnmny" wrote:

I am using W XP & Excel 2003.
I am entering latitudes and longitudes into a workbook. What I would
like to know is whether Excel can compute the distance between any 2
locations? Also can Excel convert a coordinate in latitude and
longitude format into a coordinate in UTM format?
Thanks for the help.
.



All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com