Working with geographic coordinates
 

See www.cpearson.com/excel/latlong.htm for lots of information about working
with Latitude and Longitude. Basically, you treat your coordinates as Time
values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"marinusw" wrote in message
...
I have a series of records based on latitude & longitude coordinates (with
some other associated data attached) which I got in a .txt file. I
imported
it all into Excel.

First question: How do I format the cells for latitude & longitude in
degree, minutes, and seconds? Right now the records imported into seperate
d-m-s columns.

Second question: Now that I have the data, I'd like to be able to do a
search to find which records fall within a specific radius.

Can this be done in Excel? How? If not, can anyone recommend another
inexpensive application?

Thanks for the help.