 TechArena Community What are the possible ways to convert a decimal degree to degree in Excel

# What are the possible ways to convert a decimal degree to degree in Excel

## MS Office Support

#1
 Urjavaha Member Join Date: Oct 2011 Posts: 89
What are the possible ways to convert a decimal degree to degree in Excel

Need formula to convert decimal degree (latitude/longitude) into Degree, Minutes, Seconds format. I have the following. Attitude data of 0.1741463938 and to convert to decimal degrees, I multiply by 180 which gives me decimal degrees of 31.3463508840. Now I need to convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*' represents the 'degree' symbol - did not know how to display the symbol. Need to also display whether 'N' (North) or 'S' (South) based on actual coordinate. For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40' 23.54"). Note: the '*' represents the 'degree' symbol - did not know how to display the symbol. Need to also display whether 'W' (West) or 'E' (East) based on actual coordinate. The formula needed will take the original lat/long data, multiplied by 180, and then ???? applied to deliver the data in Degrees, Minutes, Seconds format. Thank you very much for your assistance.

#2
 GALIENA Member Join Date: Jun 2011 Posts: 486
Re: What are the possible ways to convert a decimal degree to degree in Excel

I don't understand your calculations. How are you going from decimal degrees of 31.3463508840 to N34* 50' 56.04"?? Where are the extra degrees coming from? Seems to me that 31.3+ decimal degrees should yield a DMS of 31°20'46.86".
#3
 DanielaA Member Join Date: Jun 2011 Posts: 798
Re: What are the possible ways to convert a decimal degree to degree in Excel

The original data comes from a Flight Data Recorder parameter. We have to multiply the data by 180 to convert to a decimal degree format. Now what I need is to know how to convert from decimal degree (dd) to degrees, minutes, and seconds (dd mm' ss").
#4
 GaganjyotTechie Member Join Date: May 2011 Posts: 446
Re: What are the possible ways to convert a decimal degree to degree in Excel

That's fine, but there's no way 31.3463508840 decimal degrees converts to N34°50' 56.04" without adding or multiplying by another factor. 31 decimal degrees will convert to 31 degrees in DMS format, too. Again, to convert to 31°20' 46.86", just follow Chip's instructions: Divide by 24 and format using the custom format [hh]°mm'ss\".
#5
 Essien Member Join Date: May 2011 Posts: 410
Re: What are the possible ways to convert a decimal degree to degree in Excel

I can give you a sample of the same via gps entries. I have done this and want to add the tags. First, you must write your GPS readings in hours, minutes, seconds as if it were one hour, using the symbol of separation ":". To enter negative hours in Excel, write time quotes preceded by the sign "-", as attached. In this case, time does not display negative and shows ###### instead. To correct the problem, simply open the options of Excel, to go to the Calculation tab and check the '1904'. In Excel 2010 and 2007, you find that option in File / Option and you check the following In Excel 2003 and earlier, you will find this option in Tools / Option and you check the next option.
Next, you create a custom format to display the symbols DMS using the Format dialog box / cell. It is imperative to put the symbol of the time in brackets to display values ​​greater than 23. After validation, column B contains our positions at DMS.

 Thread Tools Search this Thread Show Printable Version Email this Page Search this Thread: Advanced Search Similar Threads for: "What are the possible ways to convert a decimal degree to degree in Excel" Thread Thread Starter Forum Replies Last Post How to get degree symbol (Celsius) in each cell of Excel New!life MS Office Support 2 25-02-2012 10:53 AM Bachlor degree is must for job abroad SagarP Education Career and Job Discussions 4 30-03-2011 03:32 PM Can i get a job on the base of BCA degree Soumen Education Career and Job Discussions 3 23-02-2011 05:07 PM How to convert a decimal number into words in Excel using VBA? Gandhik Windows Software 3 27-11-2010 12:59 AM Master Degree nileshtathare Education Career and Job Discussions 3 10-11-2008 07:41 PM

All times are GMT +5.5. The time now is 08:56 AM. 