See Chip Pearson's article about this:

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

"Mike Ryan" wrote:

I have a series of 12 Lat/Long co-ordinates. I want to try and put these into
excel and then Generate Intermediate co-ordinate Points. Is this possible in
excel2000? I've looked In the Format CellsNumber box but there is no option
for co-ordinates i.e. degrees, minutes and seconds.