Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Converting Grid Reference to Latitude+Longitude Info

Posted on 2014-03-01
Medium Priority
1,238 Views
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
0
Question by:sunil1982
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 43

Assisted Solution

Saqib Husain, Syed earned 40 total points
ID: 39897588
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

LVL 5

Assisted Solution

Lawrence Barnes earned 480 total points
ID: 39897704
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

LVL 33

Accepted Solution

Rob Henson earned 480 total points
ID: 39900179
0

Author Closing Comment

ID: 40113711
All are just information only, no proper solution
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
###### Suggested Courses
Course of the Month11 days, 8 hours left to enroll