Convert Latitude And Longitude To Decimal Degrees 
Convert Latitude And Longitude To Decimal Degrees  Excel 
View Answers 
Free Excel Help Forum
 Ask any question about Excel and have it answered in no time.Similar Excel Tutorials
Round to a Specific Decimal for Any Number in Excel
Round each number to a specific decimal number. This works for numbers that don't already have a decimal and ones t ...
Round each number to a specific decimal number. This works for numbers that don't already have a decimal and ones t ...
Change Minutes from a Decimal to a Percentage of an Hour
Change minutes stored as a decimal into a fraction of an hour. For instance, if time is stored as 8.15, 8 hours and ...
Change minutes stored as a decimal into a fraction of an hour. For instance, if time is stored as 8.15, 8 hours and ...
Easily Enter Fractions into Excel
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you ...
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you ...
Get the Decimal Part of a Number in Excel
How to get the decimal part of a number without any rounding in Excel. This tip allows you to simply remove the who ...
How to get the decimal part of a number without any rounding in Excel. This tip allows you to simply remove the who ...
Helpful Excel Macros
Convert Numeric Dollar Values into Text in Excel  UDF
 Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra
 Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra
Filter Data in Excel to Show Only the Top X Percent of that Data Set  AutoFilter
 This Excel macro filters a set of data in Excel and displays only the top X percent of that data. This means the highes
 This Excel macro filters a set of data in Excel and displays only the top X percent of that data. This means the highes
Replace Formulas with Values (For The Entire Workbook)
 This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
 This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel  UDF
 This free Excel UDF allows you to get the numbers out of a cell that contain both text and numbers. This is a great fun
 This free Excel UDF allows you to get the numbers out of a cell that contain both text and numbers. This is a great fun
Format Cells in The Number (Numerical) Number Format in Excel
 This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the cel
 This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the cel
Similar Topics
I am using Excel to calculate distances from latitude and longitude GPS positions. These positions have a format as follows:
S36 39.113 E174 25.945
These have been imported into a column, and using VBA I wish to separate
latitude and longitude into two other columns. In both cases the minutes
will eventually have to be express as decimals of the degrees. I don't
mind if numerous columns are used as stages to get the final answer
which is 36.234678 in one column and 174.15567 in the other.
This can be done one bearing at a time or in a loop.
Thanks Sandy
S36 39.113 E174 25.945
These have been imported into a column, and using VBA I wish to separate
latitude and longitude into two other columns. In both cases the minutes
will eventually have to be express as decimals of the degrees. I don't
mind if numerous columns are used as stages to get the final answer
which is 36.234678 in one column and 174.15567 in the other.
This can be done one bearing at a time or in a loop.
Thanks Sandy
Need formulae to convert decimal degree (lattitude/longitude) into Degree,
Minutes, Seconds format.
I have the following:
Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
by 180 which gives me decimal degrees of 31.3463508840. Now I need to
convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
represents the 'degree' symbol  did not know how to display the symbol.
Need to also display whether 'N' (North) or 'S' (South) based on actual
coordinate.
For Longitude, I have data of 0.4758427618 *180 = 85.6516971240 (decimal
degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
23.54"). Note: the '*' represents the 'degree' symbol  did not know how to
display the symbol. Need to also display whether 'W' (West) or 'E' (East)
based on actual coordinate.
The formulae needed will take the original lat/long data, multiplied by 180,
and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.
Thank you very much for your assistance.
Tim
Minutes, Seconds format.
I have the following:
Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
by 180 which gives me decimal degrees of 31.3463508840. Now I need to
convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
represents the 'degree' symbol  did not know how to display the symbol.
Need to also display whether 'N' (North) or 'S' (South) based on actual
coordinate.
For Longitude, I have data of 0.4758427618 *180 = 85.6516971240 (decimal
degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
23.54"). Note: the '*' represents the 'degree' symbol  did not know how to
display the symbol. Need to also display whether 'W' (West) or 'E' (East)
based on actual coordinate.
The formulae needed will take the original lat/long data, multiplied by 180,
and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.
Thank you very much for your assistance.
Tim
Is there a function or list of code in VBA that will convert a Military Grid Reference System (MGRS) grid to Longitude/Latitude? What is the best way to do this conversion?
i have a column of info in degrees/min/sec
example: 254802N 0503311E
How or can vert this column to decimal degrees?
example: 254802N 0503311E
How or can vert this column to decimal degrees?
Please help!
On an Excel 2007 spreadsheet I have one column for longitude and one for latitude in DDMMSS.s format (decimal minute degree).
I need to convert these cells into DD (decimal degree) format.
The mathematical formula is DD=D+M/60+S/3600, which for my case might look like DD+MM/60+SS.s/3600 if each digit is indicated.
What formula can I use to apply this conversion to each column rather than each individual cell, which would take countless hours (2000+ entries)?
On an Excel 2007 spreadsheet I have one column for longitude and one for latitude in DDMMSS.s format (decimal minute degree).
I need to convert these cells into DD (decimal degree) format.
The mathematical formula is DD=D+M/60+S/3600, which for my case might look like DD+MM/60+SS.s/3600 if each digit is indicated.
What formula can I use to apply this conversion to each column rather than each individual cell, which would take countless hours (2000+ entries)?
Are there any formulas to convert from one to the other?
Thanks
Thanks
I've got a spreadsheet that includes two cells with longitude and latitude. Google maps has a feature that allows you to input the long. and lat. coordinates into a website URL. I want to put these two things together and be able to link to a map displaying the location of the coordinates in the cells. FRUSTRATINGLY, I just can't seem to get it to work...
Here's my basic example of the cells:
L2 M2
LONGITUDE LATITUDE
29.96076 90.10341
Here's the formula I've got in my Google Maps Hyperlink Cell
=HYPERLINK("http://maps.google.com/maps?q=" &L2 & "," &M2 & ")
The basic Google maps long/lat URL is
http://maps.google.com/maps?q=LONGITUDE,LATITUDE
If the formula above was working properly it should have created:
http://maps.google.com/maps?q=29.96076,90.10341
Sadly, all this formula does is sit there on my spreadsheet like a bump on a log, it doesn't turn blue and underlined, and it doesn't bring me to google maps. What's wrong with my formula?
Please help!
Can anyone help me with this?
I have over 500 Grid ref locations that I wish to convert to Long & Lat
The following Grid ref NO305105 converts to 3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.
Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.
Any help greatly appreciated.
Davy
I have over 500 Grid ref locations that I wish to convert to Long & Lat
The following Grid ref NO305105 converts to 3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.
Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.
Any help greatly appreciated.
Davy
I need help with the formula for computing mileage between points using latitude and longitude. I have obtained this formula:
RadiusEarth*ACOS(COS(RADIANS(90(Lat1*24)))*COS(RADIANS(90(Lat2*24)))+
SIN(RADIANS(90(Lat1*24)))*SIN(RADIANS(90(Lat2*24)))*
COS(RADIANS(24*(Long1Long2))))
I have the figure for the radius of the Earth, 3956 miles.
I want to caluculated the distance of several of addresses from one address.
Can anyone assist me?
Dan
RadiusEarth*ACOS(COS(RADIANS(90(Lat1*24)))*COS(RADIANS(90(Lat2*24)))+
SIN(RADIANS(90(Lat1*24)))*SIN(RADIANS(90(Lat2*24)))*
COS(RADIANS(24*(Long1Long2))))
I have the figure for the radius of the Earth, 3956 miles.
I want to caluculated the distance of several of addresses from one address.
Can anyone assist me?
Dan
Hi All,
basically all i want is to create tree topology in excel, for example you can see in the image attached.. i need to separate which link connect to which link and which certain order.
here i attached excel file as well..
for example i have link like this
A = center of the link
A B C DF


EG
AB : 1.1
BC : 1.1.1
AE: 1.2
EG:1.2.1
CD : 1.1.1.1
DF: 1.1.1.1.1
the point is so i know i have to finished AB first then i can finish BE and BC
i have to finished BC first then CD or DF
all i have is latitude and longitude for all A, B, C, D , E, F, G sites
can i make the topology list using connection between latitude and longitude from each site?
thanks for the help, really appreciate it !
http://i54.tinypic.com/2lwpqoz.jpg
basically all i want is to create tree topology in excel, for example you can see in the image attached.. i need to separate which link connect to which link and which certain order.
here i attached excel file as well..
for example i have link like this
A = center of the link
A B C DF


EG
AB : 1.1
BC : 1.1.1
AE: 1.2
EG:1.2.1
CD : 1.1.1.1
DF: 1.1.1.1.1
the point is so i know i have to finished AB first then i can finish BE and BC
i have to finished BC first then CD or DF
all i have is latitude and longitude for all A, B, C, D , E, F, G sites
can i make the topology list using connection between latitude and longitude from each site?
thanks for the help, really appreciate it !
http://i54.tinypic.com/2lwpqoz.jpg
I need a formula that will convert degrees Lat/Long to hours minutes seconds.
Example:
32.53042 92.0901
Need to convert to:
32 31 49.5114 92 5 24.36 (With spaces in between)
Example:
32.53042 92.0901
Need to convert to:
32 31 49.5114 92 5 24.36 (With spaces in between)
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
Hi.
I will start off by stating what I want to achieve.
I do a lot of road collision analysis at work and I want to be able to plot accident locations in Google Earth.
I have put together a spreadsheet that has the collision locations in an OS Grid Reference form (Eastings & Northings). Google Earth works in Latitude & Longitude values so I cannot just drop the data into Google Earth.
The conversion process from Eastings & Northings to Latitude & Longitude is one hell of a mathematical process and one in which I dont think can be done easily in a single excel cell.
I have found a spreadsheet which offers the capability of converting East/North into Lat/Long but only one set at a time. (see below):
http://www.ordnancesurvey.co.uk/gps/...readsheet.html
I have got tens of thousands of coordinates to convert so this isnt a practical option hence question number 1:
1) Can the above spreadsheet be adapted to automate the process for all coordinates?
If the above can be done, there is then another problem that I to deal with.
Google Earth can plot points but it uses its own file convention (KML). From detailed research on the internet, I have found that it is a form of XML document. Here comes question number 2:
2) Is there a way of converting the excel spreadsheet to a KML file?
Whilst my knowledge of Excel is relatively good, my knowledge of VBA runtimes is nil so all help will be greatly recieved!!
Thanks!!
 Dan
I will start off by stating what I want to achieve.
I do a lot of road collision analysis at work and I want to be able to plot accident locations in Google Earth.
I have put together a spreadsheet that has the collision locations in an OS Grid Reference form (Eastings & Northings). Google Earth works in Latitude & Longitude values so I cannot just drop the data into Google Earth.
The conversion process from Eastings & Northings to Latitude & Longitude is one hell of a mathematical process and one in which I dont think can be done easily in a single excel cell.
I have found a spreadsheet which offers the capability of converting East/North into Lat/Long but only one set at a time. (see below):
http://www.ordnancesurvey.co.uk/gps/...readsheet.html
I have got tens of thousands of coordinates to convert so this isnt a practical option hence question number 1:
1) Can the above spreadsheet be adapted to automate the process for all coordinates?
If the above can be done, there is then another problem that I to deal with.
Google Earth can plot points but it uses its own file convention (KML). From detailed research on the internet, I have found that it is a form of XML document. Here comes question number 2:
2) Is there a way of converting the excel spreadsheet to a KML file?
Whilst my knowledge of Excel is relatively good, my knowledge of VBA runtimes is nil so all help will be greatly recieved!!
Thanks!!
 Dan
Following on from a previous post , I have a set of data which is graphed using a radar chart.
The data is a signal value measured at 1 degree intervals, 1 to 360 degrees (actually 0 to 359 degrees) and the graph shows this at one degree intervals.
The problem is the graph is too 'busy' if the axes and labels are drawn every degree, every ten degrees would do fine . Can I specify the axes to display every ten degrees, if so how?
Alternatively, how can I write a formula that will look at the column of data 0360 degrees and copy every 10th cell of data to a new column, so that the data is every ten degrees  this would be quite adequate for the graph
The data is a signal value measured at 1 degree intervals, 1 to 360 degrees (actually 0 to 359 degrees) and the graph shows this at one degree intervals.
The problem is the graph is too 'busy' if the axes and labels are drawn every degree, every ten degrees would do fine . Can I specify the axes to display every ten degrees, if so how?
Alternatively, how can I write a formula that will look at the column of data 0360 degrees and copy every 10th cell of data to a new column, so that the data is every ten degrees  this would be quite adequate for the graph
I wish to convert a number to a degree using the Tan function
the example given is
opposite side of triangle 333/ adjacent side 769
equals .43
TAN(0.43) = 23.27degrees
I tried it on a calculator  no good
so I tried it in Excel  same  I got .458621
but not in degrees. ( I thought TAN gave degrees ? )
I'm mathematically challenged as it's a long time since I was at school
could some kind person show me the way please
thanks Keith
the example given is
opposite side of triangle 333/ adjacent side 769
equals .43
TAN(0.43) = 23.27degrees
I tried it on a calculator  no good
so I tried it in Excel  same  I got .458621
but not in degrees. ( I thought TAN gave degrees ? )
I'm mathematically challenged as it's a long time since I was at school
could some kind person show me the way please
thanks Keith
Hi, I have to convert degrees F into degrees C and vice versa and I know the convert function in excel is there but I don't want to have to use a formula in a cell all the time. Is there a way to run the function using a macro?
So, for instance, i run thee macro and a comment box opens where i can select the cell with the number to convert, and then it gives me options of the unit i want it from and to, and then it changes to the new value. Is this possible?
It would be a timesaver for me if so.
Thanks in advance.
So, for instance, i run thee macro and a comment box opens where i can select the cell with the number to convert, and then it gives me options of the unit i want it from and to, and then it changes to the new value. Is this possible?
It would be a timesaver for me if so.
Thanks in advance.
Good Afternoon, I am currently working on a project and need some help data mining a extract from a database that's in excel.
Some of the data I was given has latitudes and longitudes which are valuable to me but some of the information was entered incorrectly and the lat and long columns have only zeroes for some entries. I used some VBA to sort out all the ones that have zeroes in the lat and long columns because I noticed in a comments block some of them have the latitude and longitude placed in the comments instead of the designated spot.
An example of one of the comment cells is this:
Search and Rescue 30NM S MARTHA'S VINEYARD 4037.4N 07043.3W MEDEVAC OF 35YOM E
As such the problem I am having is figuring out how to search through the cells for ones that have a lat and long in them since there is other information and numbers in the comment cell. Keep the cells that have latitudes and longitudes and get rid of the rest. The red highlighted information is what is valuable to me. Another problem is not all of the latitudes are in that format sadly as can be seen by this example cell:
SAR Unreported Vessel/ 42 01. N 067 25. W CLOSED AREA II/041527ZAUG06
If anyone has any insight/references into how I could go about doing this I would pretty much owe you my life since doing it manually would take ages for myself and my group on this project.
Thanks!
Some of the data I was given has latitudes and longitudes which are valuable to me but some of the information was entered incorrectly and the lat and long columns have only zeroes for some entries. I used some VBA to sort out all the ones that have zeroes in the lat and long columns because I noticed in a comments block some of them have the latitude and longitude placed in the comments instead of the designated spot.
An example of one of the comment cells is this:
Search and Rescue 30NM S MARTHA'S VINEYARD 4037.4N 07043.3W MEDEVAC OF 35YOM E
As such the problem I am having is figuring out how to search through the cells for ones that have a lat and long in them since there is other information and numbers in the comment cell. Keep the cells that have latitudes and longitudes and get rid of the rest. The red highlighted information is what is valuable to me. Another problem is not all of the latitudes are in that format sadly as can be seen by this example cell:
SAR Unreported Vessel/ 42 01. N 067 25. W CLOSED AREA II/041527ZAUG06
If anyone has any insight/references into how I could go about doing this I would pretty much owe you my life since doing it manually would take ages for myself and my group on this project.
Thanks!
How can I create a format to display a number that is in decimal degrees, in
Degree:minute:second?
Degree:minute:second?
Hi all,
I have done a search but couldn't find anything that helped.
I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.
Any hints on how to write the equation?
I have done a search but couldn't find anything that helped.
I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.
Any hints on how to write the equation?
I'm a novice at using macros in excel and I need to convert 3 columns and 255 rows of decimal numbers into hexidecimal numbers. I've done the easy part and created buttons on my excel sheet, one button to convert to hex and the other to convert back to decimal. Can anyone help me with the VBA code to get these buttons working?
Using Chart, Add Trendline, then selecting Linear in Excel to chart a linear
regression line on a series creates a new line on my chart with either a
positively or negatively sloped regression line.
Is there any way, using this builtin Excel feature, to convert the result
into degrees so that I can then label the regression line in degrees, for
example, 45 degrees?
My thanks for any ideas. Brad
regression line on a series creates a new line on my chart with either a
positively or negatively sloped regression line.
Is there any way, using this builtin Excel feature, to convert the result
into degrees so that I can then label the regression line in degrees, for
example, 45 degrees?
My thanks for any ideas. Brad
Hi all,
I may be pushing the limits of this board with this question, but does anyone know if there is a code that can calculate the the distance between the latitude and longitude of two points on a map. For example, how can I calculate the distance between these two points. Thanks for any help.
.......................................Long: Lat:
Albuquerque NM 106.6225897 35.0846
Las Cruces NM 106.716125 32.6621
I may be pushing the limits of this board with this question, but does anyone know if there is a code that can calculate the the distance between the latitude and longitude of two points on a map. For example, how can I calculate the distance between these two points. Thanks for any help.
.......................................Long: Lat:
Albuquerque NM 106.6225897 35.0846
Las Cruces NM 106.716125 32.6621