MGRS to Decimal conversion

[KLLRDRAGON]

I have a question that I am hoping someone here can help me with. I am trying to convert MGRS coordinates (12S YG XXXX XXXX) to decimal (35.XXXX, 115.XXXX) format. I would like to do this in VBA if possible, but I am not having much luck finding code that will work. Can anyone here help?

 

[Gerald Higgins]

Hi, welcome to the board.

I don't really know much about this - in fact I didn't know what MGRS co-ordinates are, so I Googled it, and found several free software products that claim to do this conversion.

For example this one
http://freegeographytools.com/2007/mgrsutmlatitude-longitude-converter

I have no idea if it's any good or not

 

[RMR]

removed...incorrect data given

 

[alansidman]

Was looking for something similar to aid in geocaching and found this.

http://www.uwgb.edu/dutchs/usefuldata/UTMFormulas.HTM

Scroll down to find a spreadsheet that you can download that has all conversions you may need.

Alan