Displaying Global position data

R

raisun

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
 
J

JE McGimpsey

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