Data in Degrees, Minutes, Seconds

Hi

You can enter the data as time and use a custom format.

Ex. to enter 135 degrees 43 minutes and 22 seconds, enter

135:43:22

and format the cell with the custom format string:

[h]"d "mm"m "ss"s"

You'll see in the cell

135d 43m 22s

To get the value in decimal use

=A1*24

and format the cell as number.

In the same case you'd get:

135.723

Also one of those obscure things that I know, but I'm not really sure why:

The key combination (hold)[ALT] + 0176 will give you the degrees symbol.

135° 43' 22"

and so on.