Convert between latitude and decimals in Excel

Degrees minutes seconds in Excel IME:

ALT+41443 stands for "°"
ALT+41444 stands for "the"
ALT+41445 stands for "the"

Excel degrees Seconds to decimal method:

=left (m40,3) +mid (M40,find ("°", M40) +1,2)/60+mid (M40,find ("'", M40) +1,2)/3600
Note: (m40,3) the degree has 3 digits, the same as seconds. The second digit is still counted as a decimal.
MID: Returns a special number of characters starting at the specified position in the text string

Excel decimal conversion to degrees minutes seconds method:

=int (A1) & "°" &int ((A1-int (A1)) *60) & "" "&round (((A1-int (A1)) *60-int ((A1-int (A1)) *60) *60,0) &" ″"
INT: Rounding any real number down to the nearest integer
Round: Rounding to a certain number of digits

Convert between latitude and decimals in Excel