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.
.