Hi Gap,
Very useful tool, but I must be doing something wrong as when I enter a new position in Lat and Long, the Locations and Units lat and longs don't calculate correctly eg:-
lat 43 5' 12" N, 3 12' 12" W gives a
Location Lat of 0.000.043 and Long of -0.000.003 and a
Units Lat of 5.170.400 and Long of -0.384.400.
The position shows correctly on the maps though. Excel 2010.
Any idea what is happening?
Regards,
MLF