Hi Mahesh,
Here's How to do Logic: 1.The whole units of degrees will remain the same (i.e. in 9.73877° Decimal, start with 9°). 2.Multiply the decimal by 60 (i.e. .73877 * 60 = 44.3262). 3.The whole number becomes the minutes (44'). 4.Take the remaining decimal and multiply by 60. (i.e. .3262 * 60 = 19.572). 5.The resulting number becomes the seconds (6"). Seconds can remain as a decimal. 6.Take your three sets of numbers and put them together, using the symbols for degrees (°), minutes (‘), and seconds (") (i.e. 9°44'19.572" Degree). Below are the formulas to achieve this in excel: Decimal Degree Minute Seconds 9.73877 =INT(A2) =INT((A2-INT(A2))*60) =(((A2-INT(A2))*60)-INT((A2-INT(A2))*60))*60 Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: Friday, September 25, 2009 4:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ how to change decimal ccoordinates into DDMMSS fromat Dear friends, Need your help. i want to convert decimal coordinates into DDMMSS. 9.73877 = 09 44 20 -- With Love, Mahesh Bisht --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---