1, after the start of Excel, in A, B columns enter the following data, C, D columns as the output of the conversion.

2, the main use of Text function, the specific content, converted to the required format, in cell B3 enter the latitude and longitude test data: 50.454564. In column C enter the formula: = TEXT (B3/24, "[h]°m′sss.000″) can be completed with the conversion of numerical values and degrees minutes and seconds.

3, Text the function will be converted to text, and allows you to use a special format string to specify the display format.

4, in the input latitude and longitude in the second data, you need to be accurate to the fourth second after the minute. Entry formula: = TEXT (INT (B3), "0") & "°" & TEXT (INT ((B3-INT (B3))*60), "00") & "′" & TEXT (((B3-INT (B3))*60-INT ((B3-INT (B3))*60))*60," 00.0000")&"″" will do.

5, with the replacement function, respectively, to obtain degrees, minutes, seconds of the value of the calculation to complete the conversion. In column C enter the formula: = SUBSTITUTE (SUBSTITUTE (SUBSTITUTE (A3, "°", ":"), "′", ":"), "″",) * 24 can complete the conversion of numerical values and degrees, minutes and seconds.