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...
Who is Participating?
Rob HensonConnect With a Mentor Finance AnalystCommented:
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.
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.
sunil1982Author Commented:
All are just information only, no proper solution
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.