Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need to learn how to change Degre decimals into DMS
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2013, 07:05 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Exclamation Need to learn how to change Degre decimals into DMS

Hi i really need to know how to turn degree decimals into degree minute seconds... I have to build something to calculate a compass rule...so that means to be able to + - / and * angles..... please help
Reply With Quote
  #2  
Old 11-22-2013, 10:42 PM
jolivanes jolivanes is offline Need to learn how to change Degre decimals into DMS Windows XP Need to learn how to change Degre decimals into DMS Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default
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''") 
Reply With Quote
  #3  
Old 11-23-2013, 01:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,777
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Hi
have a look at this page
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 11-23-2013, 12:25 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
Thanks i hope it will make it easy since the full legal page will be full of equations... i hope i wont have to enter for each one...
Reply With Quote
  #5  
Old 11-23-2013, 12:27 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
Quote:
Originally Posted by jolivanes View Post
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....
Reply With Quote
  #6  
Old 11-23-2013, 01:11 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
Not working for me .. I only know basics in excel i really need a hand here... please!
Reply With Quote
  #7  
Old 11-23-2013, 02:08 PM
jolivanes jolivanes is offline Need to learn how to change Degre decimals into DMS Windows XP Need to learn how to change Degre decimals into DMS Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default
Could you attach a stripped down version of your file with before and after examples.
No personal information in it though.
I see you have Windows 7 - 64 bit. Make sure people who are not that far advanced can open your file (xls or xlsx or xlsm)
Reply With Quote
  #8  
Old 11-23-2013, 03:28 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
here is all i have for now since i need to + - * / angles and its not working properly if i cant put it into DMS.... Im not so advanced in excel...
Attached Files
File Type: xlsx Compass rule.xlsx (12.0 KB, 7 views)
Reply With Quote
  #9  
Old 11-23-2013, 03:29 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
forgot to mention its french
Reply With Quote
  #10  
Old 11-23-2013, 05:27 PM
jolivanes jolivanes is offline Need to learn how to change Degre decimals into DMS Windows XP Need to learn how to change Degre decimals into DMS Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default
Like this? (See attached)
Attached Files
File Type: xlsx Compass rule V1.xlsx (12.7 KB, 10 views)
Reply With Quote
  #11  
Old 11-23-2013, 07:43 PM
ferfer25 ferfer25 is offline Need to learn how to change Degre decimals into DMS Windows 7 64bit Need to learn how to change Degre decimals into DMS Office 2013
Novice
Need to learn how to change Degre decimals into DMS 		 
Join Date: Nov 2013
Posts: 7
ferfer25 is on a distinguished road
Default
awsome! is there any way that it goes directly in that cell? or i really have to have both? like if it was $?
Reply With Quote
  #12  
Old 11-23-2013, 10:48 PM
jolivanes jolivanes is offline Need to learn how to change Degre decimals into DMS Windows XP Need to learn how to change Degre decimals into DMS Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default
Change the D4 in the formula to C4+F27. (See attached)
Attached Files
File Type: xlsx Compass rule V2.xlsx (12.7 KB, 8 views)
Reply With Quote
  #13  
Old 11-23-2013, 11:11 PM
macropod's Avatar
macropod macropod is offline Need to learn how to change Degre decimals into DMS Windows 7 32bit Need to learn how to change Degre decimals into DMS Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
All you really need to show decimal degrees in DMS format is to apply a custom number format to the cell and to multiply the decimal degrees by 24. The custom number format is:
[hh]º mm' ss''
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


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
Need to learn how to change Degre decimals into DMS How to change save location and file to print name change? albertc Excel Programming 1 05-13-2012 07:05 PM
Need to learn how to change Degre decimals into DMS change the view to final, my change bars disappear. I need them visible anna.a.julin Word 1 03-01-2012 08:05 PM
Need to learn how to change Degre decimals into DMS 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 09:01 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft