| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Is there a convenient way to represent latitude/longitude
Positions are often given in lat/lon in deg/min/sec units. Is there a way to
represent this in Excel (other than a separate cell for each component) - similar to date/time? |
|
#2
|
|||
|
|||
|
Here's a site that converts in both directions.
http://www.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html I prefer to use decimal equivalents because I find it more intuitive. |
|
#3
|
|||
|
|||
|
See if Chip's site helps http://www.cpearson.com/excel/latlong.htm
-- HTH Bob Phillips "iman1000" wrote in message ... Positions are often given in lat/lon in deg/min/sec units. Is there a way to represent this in Excel (other than a separate cell for each component) - similar to date/time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want to create a simple yes/no spreadsheet with a dot represent. | Excel Discussion (Misc queries) | |||
| Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
| how do i represent numbers with letters | New Users to Excel | |||
| How do I get a letter to represent a number for scheduling? | Excel Worksheet Functions | |||
| How do I represent data in a cell as hexadecimal without converti. | Excel Discussion (Misc queries) | |||
Hybrid Mode
