Displaying Global position data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Lat/Lon coordinates to Decimal 4
Special Format for Angular data in degrees 7
Convert decimal degree (lattitude/longitude) into Degree, 5
Measure out this geometry right-angle for me 7
degrees decimal minutes format for latitude longitude 2
charting bearing and distance 2
Displaying time gaps 6
how can I make this code run faster 8

Back
Top