Re: converting degrees minutes seconds to decimal degrees

Tech-Archive recommends: Fix windows errors by optimizing your registry

dano -

A general Google search of "excel latitude longitude" (without the quotes)
yields

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

- Mike
www.mikemiddleton.com

"dano" <dano@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:dano-EC651E.12225225062006@xxxxxxxxxxxxxxxxxxxxxxx
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...?

--
"What we need now are killfiles that really kill." - alt.fan.jwz


.

Relevant Pages

  • Re: DMS to DD
    ... In terms of how to work with DMS in Excel, ... 'Format to Degrees, Minutes, Seconds - MrExcel Message Board' ...
    (microsoft.public.excel.programming)
  • Re: Can excel read numbers in the Sexagesimal system (DMS)?
    ... >Can excel read numbers in the Sexagesimal system (DMS)? ... So long as you use the decimal separator, Excel can convert your input to the ... decimal equivalent. ...
    (microsoft.public.excel.worksheet.functions)