Google Maps Function to show Kilometers instead of meters.

[Challebjoern]

Hey guys. I got this code from "TheAnalystCave" and think it worked quite well. The only things that confuses me is that I can't find how to change the value of distance. It shows meters to me but I want it to show Kilometers instead, any suggestions of where I can change that?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Kenneth Hobson]

Use =Convert or change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Challebjoern]

Worked like a charm Kenneth! Thanks alot!

[Challebjoern]

Got any quick way to show the distance in a cell? Now I've made a button which I have to press to show it, I kinda want it to show in a cell below once i press enter when the destination is filled in.

Use =Convert or change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Kenneth Hobson]

If you mean that you have the inputs in A and B columns and the UDF formula in say C then that uses A and B then it should work.

[Challebjoern]

That's exactly what I mean. So I write destinations "From: in A1" and "To: in A3" and I want to show the distance "Total distance xx km: in A6". What formula do I use for that?

If you mean that you have the inputs in A and B columns and the UDF formula in say C then that uses A and B then it should work.

[Kenneth Hobson]

In A6:
=GetDistance(A1, A3)

[Challebjoern]

You're the best Kenneth! Super thanks!

In A6:
=GetDistance(A1, A3)