How to Convert degree from decimal number to the standard format (degree °
minutes ´ seconds?.
I tried custom but could not work out for some degrees.
Thanks
Here's one way:
Divide your decimal degrees by 24. Then format the cell as:
Format/Cells/Number/Custom Type: h° m' s.00\"
Note that the degree symbol after the h is entered by holding down the <alt>
key and then typing 0176 on the numeric keypad; then release the <alt> key.
Using the above,
with 5.954 in A1;
B1 formatted as above;
B1 containing the formula =A1/24,
B1 will show: 5° 57' 14.40"
--ron