Urgent formula required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechnoGram - 21 Jan 2008 18:14 GMT

need formula to change a gps settings in spreadsheet from UTM to
longtitude and latitude.... Any ideas?

Reply to this Message

Niek Otten - 21 Jan 2008 18:33 GMT

Look here:

http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| need formula to change a gps settings in spreadsheet from UTM to
| longtitude and latitude.... Any ideas?

Reply to this Message

JP - 21 Jan 2008 18:41 GMT

LOL Niek :-)

> Look here:
>
[quoted text clipped - 5 lines]
> Niek Otten
> Microsoft MVP - Excel

Reply to this Message

JP - 21 Jan 2008 18:39 GMT

How about this?

http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM

HTH,
JP

> need formula to change a gps settings in spreadsheet from UTM to
> longtitude and latitude.... Any ideas?

Reply to this Message

Gord Dibben - 21 Jan 2008 19:21 GMT

How does Niek's URL differ from yours?

http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM ..Niek's post

http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM .JP's post

Gord Dibben MS Excel MVP

>How about this?
>
[quoted text clipped - 5 lines]
>> need formula to change a gps settings in spreadsheet from UTM to
>> longtitude and latitude.... Any ideas?

Reply to this Message

JP - 21 Jan 2008 22:01 GMT

It doesn't. FYI his post hadn't appeared when I started composing my
reply.

Thx,
JP

> How does Niek's URL differ from yours?
>
[quoted text clipped - 3 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Gord Dibben - 21 Jan 2008 23:06 GMT

I see.........the LOL in your one post was in reference to you both posting the
same URL.

Now, I get it<g>

Gord

>It doesn't. FYI his post hadn't appeared when I started composing my
>reply.
[quoted text clipped - 9 lines]
>>
>> Gord Dibben MS Excel MVP

Reply to this Message

TechnoGram - 22 Jan 2008 02:51 GMT

> I see.........the LOL in your one post was in reference to you both posting the
> same URL.
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Thank you, thank you, thank you (did I miss anyone? LOL)
Absolutely perfect, could not have asked for anything better.... you
all rock!

Reply to this Message

JP - 22 Jan 2008 14:03 GMT

Yes!

Thanx for your concern.

--JP

> I see.........the LOL in your one post was in reference to you both posting the
> same URL.
[quoted text clipped - 8 lines]
> >Thx,
> >JP

Reply to this Message