This has been a great tool but I have a problem. When I carry put the function the latitude and longitude outputs are displayed as -338585403 and 1511166430 not as -33.4800462, 150.1389424 which is needed to plot it on a map. Its a large dataset so cannot do this manually. How can it be solved?
Prof. Anwar, with the save yet again. Thanks for the help!
Moulay, Thank you so much for this video. You have saved me hundreds of hours by making this video. Thank you.
Very happy to hear this.
Thanks for this! Very helpful. 🙂
if my table were of postcodes , 'weeks' and cases, how would i be able to show case postcodes on the map by selectable week?
This has been a great tool but I have a problem. When I carry put the function the latitude and longitude outputs are displayed as -338585403 and 1511166430 not as -33.4800462, 150.1389424 which is needed to plot it on a map. Its a large dataset so cannot do this manually. How can it be solved?
make a new column and divde the orginal number by 10000000 in that column. e.g. =A2/10000000
@@sounny Thanks, it is almost a frustratingly easy solution to a problem which had caused some frustration, thank you.