converting degrees minutes seconds to decimal degrees

D

dano

Attempting to convert lat/long from degrees minutes seconds (dms) to
decimal degrees (dd). That is, I have data in dms and enter that into
columns of latitude and longitude. I want each cell to convert the dms
to dd.

I'm not able to find the formula or method in Excel Help (Excel 2004
11.2.4) or in a Google Groups search of this ng. There must be a way to
do this simple operation though...?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Converting decimal degrees to degrees, minutes & seconds 2
Converting GPS coordinates to decimal in Report 0
translate degrees to latitude longitude 3
using macro in form to convert XY coordinates 1
Degrees Minutes Seconds 3
degrees decimal minutes format for latitude longitude 2
DMS to degree conversion in excel 1

Top