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