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

"Charlotte E." wrote in message
...
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".

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:
"Charlotte E." wrote in message
...
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. 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

hi,

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

isabelle


Le 2013-01-21 13:39, Charlotte E. a écrit :
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