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.
 
You must log in or register to reply here.

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

degrees 3
Is there a convenient way to represent latitude/longitude 2
Special Format for Angular data in degrees 7
Converting Lat/Lon coordinates to Decimal 4
Latitude and Longitde problem 3
Convert decimal degree (lattitude/longitude) into Degree, 5
Measure out this geometry right-angle for me 7
ViewSonic VG2757V-2K Display with Inbuilt Webcam and Multifunctional Docking Station Unboxing 4

Back
Top