Need to learn how to change Degre decimals into DMS

ferfer25 · #1 11-23-2013, 07:43 PM

awsome! is there any way that it goes directly in that cell? or i really have to have both? like if it was $?

jolivanes · #2 11-23-2013, 10:48 PM

Change the D4 in the formula to C4+F27. (See attached)

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