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

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
(E-Mail Removed)



"Asa_johannesen" <(E-Mail Removed)> wrote in message
news:0DD6E1A4-7E35-410D-8F06-(E-Mail Removed)...
> 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

Hi Asa,

Look here:

http://www.cpearson.com/excel/latlong.htm

It's the 4th item

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Asa_johannesen" <(E-Mail Removed)> wrote in message
news:0DD6E1A4-7E35-410D-8F06-(E-Mail Removed)...
| 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