# Convert Latitude longitude to 6 digit OS grid Ref

1. ## Convert Latitude longitude to 6 digit OS grid Ref

Hi,

I am looking for a macro or formula to convert GB Latitude longitude Ref to 6 digit OS grid Ref. I have 20 + Latitude longitude Ref to convert at a time,

Thank you for looking at this,

Cheers

WCE

2. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

I have not seen one. Not being in Britain, I probably would never have known anything about OS grid, so thank you for helping me learn something new today.

In the spirit of "let me google that for you," I put this into a search engine, and this http://www.movable-type.co.uk/script...g-gridref.html was one of the first sites the search returned. He explains that "the maths [for converting lat/long to OS grid] are very complex." He also includes a functional calculator and javascript source code for his conversion. Someone who is familiar with coding could probably adapt the javascript code to a spreadsheet and/or VBA procedures to perform the same calculation.

He also has a link to the Ordnance Survey's website Guide to coordinate systems in Great Britain, where they appear to have a calculator and a 2002 Excel spreadsheet for these calculations.

Hopefully that will give you a good start.

3. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

Hi WCE_123

Try the Ordinance Survey site.

http://www.ordnancesurvey.co.uk/oswebsite/index.html

Coordinate transformer

4. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

Thank you for your reply - The problem I have is the bulk of conversions I have to do as mentioned this could be as many as 60, I have this task most days so you can understand the need for a conversion tool to deal with multiple inputs instead of one at a time,

Cheers again

WCE

5. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

See attached.

6. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

All the code you need is in the worksheet that can be downloaded from the OS Site as MrShorty mentioned.

You could even automate entering co-ordinates in the 'Enter coordinates here' worksheet and reading back the OS grid reference.

That could be done for as many sets of lat/long you wanted.

7. ## Re: Convert Latitude longitude to 6 digit OS grid Ref

Hi Norie,

Would it be possible to help with the automating of the co-ordinate input and reading back, this would be great,

Cheers

WCE

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1