Converting Grid Reference to Latitude+Longitude Info

sunil1982
sunil1982 used Ask the Experts™
on
Hi ,

How can I convert Grid Reference to Latitude+Longitude Info.

Can you share me the formula or ..

VBA Code to enable in the worksheet...

I am attaching a sample file...
LATLONG-GRID.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I think you ought to ask this question in the maths forum and not in excel forum.

In any case, the coordinates you have provided are connected to a local system and you have to provide the parameters of that local system to be able to convert to the longitude/latitude.
Without a grid reference point and and scale there is not a way to correlate this to latitude/longitude.  Below is an article explaining how this could be done manually.

http://www.ehow.com/how_8788145_convert-grid-coordinates-latitude-longitude.html
Finance Analyst
Commented:

Author

Commented:
All are just information only, no proper solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial