Need to learn how to change Degre decimals into DMS

		Microsoft Office Forums > Microsoft Excel > Excel
Need to learn how to change Degre decimals into DMS

11-22-2013, 10:42 PM

jolivanes

Windows XP Need to learn how to change Degre decimals into DMS

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

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''")

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:31 PM.