Need to learn how to change Degre decimals into DMS

jolivanes · #1 11-22-2013, 10:42 PM

Either formula (Degr-Decimal) is in A1

PHP Code:


			
=SUBSTITUTE(TEXT(ABS(B1)/24,"[hhh] mm ss.000"),"."," ")

PHP Code:


			
=TEXT(ABS(A1)/24,"[h] m' s.00''")

ferfer25 · #2 11-23-2013, 12:27 PM

Quote:

Originally Posted by jolivanes

Either formula (Degr-Decimal) is in A1

PHP Code:


			
=SUBSTITUTE(TEXT(ABS(B1)/24,"[hhh] mm ss.000"),"."," ")

PHP Code:


			
=TEXT(ABS(A1)/24,"[h] m' s.00''")

Is there a way without having to see the DD? cuz if not i wont have enough room on the page....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Prices from decimals to ticks	rollie	Excel	1	11-17-2012 08:08 PM
if letter change font also change	gsrikanth	Excel	1	05-15-2012 03:03 AM
How to change save location and file to print name change?	albertc	Excel Programming	1	05-13-2012 07:05 PM
change the view to final, my change bars disappear. I need them visible	anna.a.julin	Word	1	03-01-2012 08:05 PM
FREE resources to learn M$ products...	zyzzyva57	Office	4	05-16-2009 07:31 AM