Hi Asa,

Look he

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

It's the 4th item

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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