LinkBack URL
About LinkBacks
Good Morning
I would like to ask how to convert, using excel2007, cordinates:
1. Latitude
Column A Column B Column C
10 10 10
2. Longitude
Column A Column B Column C
10 10 10
to latitude and longitude number such as 10.10 and 10.10
Thnak you.
Coordinates
Good Morning
I would like to ask how to convert, using excel2007, cordinates:
1. Latitude
Column A Column B Column C
10 10 10
2. Longitude
Column A Column B Column C
10 10 10
to latitude and longitude number such as 10.10 and 10.10
Thnak you.
use the & symbol.
as in
=A1&"."&B1
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Are you using this for further calculations?
Try this for longtitude, and positive latitude
Format the cells > Number format > Custom
Please Login or Register to view this content.
Type:=
For a further explanation see these linksPlease Login or Register to view this content.
Chip Pearson - Latitude, Longitude,And Great Circles
Contextures - Excel Latitude and Longitude Calculations
[EDIT]
This workbook might help
Last edited by Marcol; 06-07-2012 at 05:59 AM. Reason: Added Attachment
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks