Are you substituting DD with the cell reference containing the decimal value
or are you naming the cell with the value and calling it DD ?

and the DMS must be referenced as a cell or named range.

This maybe why it does not work?

--

Regards,
Nigel




"Asa_johannesen" wrote in message
...
Hi.

Can anyone help me? I have a GPS waypoint in decimal, and I need to
convert
it to degrees etc. I have a formula I found online, but it doesn't work. I
don't know excel well enough to see where the error is so I'll paste it
here.
Either way, if someone knows a formula for doing the conversion, I'd be
very
grateful if you could post it here.

DMS = TRUNC(DD)&",d ", &TRUNC((DD-TRUNC(DD))*60)&",m",
&INT(((B6-TRUNC(DD))*60-(TRUNC((DD-TRUNC(DD))*60)))*60*10)/10&",s",,",",)

Thank you.

Asa