knickel,

Put the whole degrees in A1 and the minutes portion in B1.
In C1 put the formula
=A1+B1/60
In D1 put the formula
A1&" "&INT(B1)&" "& MOD(B1,1)*60

For 39 in A1 and 56.811 in B1, this will give you
In C1
39.94685
and in D1
39 56 48.66

There may be a way of putting 39 56.811 in one cell, getting excel to look
for the space and extracting the degrees and minutes portions.
I don't know how to do that in a formula but I can do it in a macro, if
that's any use to you.
If it's possible to do it in a formula, someone else here will know how.

Henry

wrote in message
oups.com...
Thanks very much for the comments thus far. I have tried Chip's page,
but it converts from decimal to degrees minutes seconds (D M S) without
the middle step. I need to start with the middle step (degrees
minutes.decimal), and go to decimal and degrees minutes seconds.

For instance, starting from 39 56.811 / 83 2.919 to:

Decimal: 39.94685 / 83.04865
D M S: 39 56 48.66 / 83 2 55.14

I have a mapping program for my county of residence that will provide
the format above, and I need to convert these coordinates into the
formats used by other folks that I work with. Again, thank you for your
assistance. It is greatly appreciated.

Kit Nickel