Converting UTM to Google Earth coordinates?

[Charlotte E.]

Hi,


I have this UTM coordinate:

0720898,38 E
6171176,68 N

....how do I get Excel to calculate this UTM coordinate into the
longitude/latitude format, used by Google Earth in the KML/KMZ files?

Thanks you in advance,


CE

 

[MerseyBeat]

Hi,


I have this UTM coordinate:

0720898,38 E
6171176,68 N

...how do I get Excel to calculate this UTM coordinate into the
longitude/latitude format, used by Google Earth in the KML/KMZ files?

Thanks you in advance,


CE

I don't believe it is an easy conversion with a simple formula. Googling
UTM to longitude/latitude conversion will yield a number of useful sites
that may help with the "math".

 

[Charlotte E.]

You're right - not easy to do with a simple worksheet function...

....so, I decided on an UDF instead

BTW: What's the correct English term: 'A UDF' or 'An UDF'???

It's called 'A function', right?
But, 'An User', right?

So, what to put in front of 'UDF'???


CE



Den 21.01.2013 19:50, MerseyBeat skrev:

 

[GS]

Charlotte E. wrote :

It's called 'A function', right?
But, 'An User', right?

So, what to put in front of 'UDF'???

Charlotte,
It's *a user defined function* IMO!<g>

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[isabelle]

hi,

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

isabelle


Le 2013-01-21 13:39, Charlotte E. a écrit :