BD (Baby Daughter) has been tasked with converting some Lat-Long deg-min-sec coordinates to decimal. There are a number of Web services to accomplish this, several with .gov TLDs, more with .EDU TLDs.
There are also several forae that discuss Excel macros to accomplish this end.
However, nothing I've found so far really fills the bill
BD's requirements are to take a [significant] number of degrees-minutes-seconds
values and convert them to a decimal equivalent. I'm thinkin' it would be nice to be able to reverse that process, as well.
It's been a decade since I did anything with Excel (Office 2000), so I'm more than a bit rusty
Checked DC - several discussions involved - but nothing I found seems to cover this.
Anyone have a pointer to such a bit of code? (I'd personally prefer an application for this, but considering the number of conversions to be made - and corporate paranoia - a spreadsheet solution would be better). (If it matters, they are using Office 2003, soon to upgrade to 2007: really progressive