| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Global position data
EXCEL format to display lat/long in deg min secs not a s text but as written
or as fraction of degrees? eg. 25d30m30s = 27.51 degrees |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Global position data
If 25d30m30s is a text entry (rather than done by formatting), you can't
change the format to display d.000, but you could use this formula: =ROUND((SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"d",": "), "m",":"), "s","")) * 24, 2) Note, I don't know how you got 27 degrees - I'm assuming that's a typo. In article , raisun wrote: EXCEL format to display lat/long in deg min secs not a s text but as written or as fraction of degrees? eg. 25d30m30s = 27.51 degrees |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying a cell relative to the position to another cell | Excel Discussion (Misc queries) | |||
| How insert a dash in the third position of a column with data? | Excel Discussion (Misc queries) | |||
| XL97: Position text boxes (or data labels) w/out VBA | Charts and Charting in Excel | |||
| auto position of data labels in a line chart | Charts and Charting in Excel | |||
| How can I change the position/format for all data labels in a ser. | Charts and Charting in Excel | |||
Hybrid Mode
