I remember this thread but I'm too lazy to look it up.
Someone was looking for Excel formulae to convert degrees back and forth.
Here's how I handle it;
The formula is in the formula bar.
The formatting of the cell showing symbols and the value typed in. Notice no decimal until after the whole seconds value. In order to get the degrees symbol into the format, I had to copy and paste into the format. Sneaky.
And the reverse;
The formatting is for hours, minutes, and seconds but who cares, it's the same.
I started putting degrees, minutes and seconds in separate cells in the 1990s because the Intel processors then couldn't handle large numbers without rounding errors (e.g. trying to split one number into separate pieces). I still do it that way and it makes converting to decimal degrees easy.
What the heck, more tips.
Converting milliarcseconds of time into decimal degrees;
Converting milliarcseconds into decimal degrees;
Thanks Scott. VERY useful. I wish we could just use grads...
Who is our friend in New Zealand that wrote a complete Excel add-on that does all this sutff? Mr. Fox I believe? I think his name is Jim. I'm not certain. I have written these conversion routines in several different programming languages. They aren't fun. SPC to lat-lon was the toughest. It took me a couple days just to weed through the math (thank goodness I was also a math major). A couple more days to write the program.
Only a number-head versed in programming languages could have managed that trick.
Lucky me.