Converting Grid Reference to Latitude+Longitude Info

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
sunil1982Asked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
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.
0
 
Lawrence BarnesConnect With a Mentor Commented:
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
0
 
sunil1982Author Commented:
All are just information only, no proper solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.