Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 06-17-2013, 10:11 PM
fzuazua fzuazua is offline How to write the degree, minute second format in excel Windows XP How to write the degree, minute second format in excel Office 2003
Novice
 
Join Date: Jun 2013
Posts: 2
fzuazua is on a distinguished road
Default Decimal degrees to Deg Min Sec

If cell “E19” is 78.359272 in degrees decimal then:
CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
Will return:
78° 21' 33.38"
It may seem complicated but it give the exact format to put in to Google Earth or similar software. U can do all your calculations in decimal. If u use radians u must convert to degrees before applying the formula.
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to write the degree, minute second format in excel Excel 2007 cell format help!!! Raner Excel 4 06-17-2013 11:13 PM
How to write the degree, minute second format in excel Excel convert format [h]:mm:ss to decimal gchan2000 Excel 1 08-17-2010 01:36 PM
Updating excel link alters table format in PP dbmagnus PowerPoint 0 06-03-2010 12:12 PM
Need help in format or link in excel handsome1968 Excel 1 05-01-2010 09:20 AM
How to write the degree, minute second format in excel Format Excel to look like Word Kilconey Excel 1 04-30-2010 09:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 AM.


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