Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel tool for the conversion of following lat/long:

Lat: 23° 11’ 24.67503’’ S Long: 118° 46’ 6.15742’’ E , which gives me following N,E:

Northing: 7,434,317.43

Easting: 680,991.69

But I am not clear that why conversion of the N,E back to Lat/Long is not giving me same results i.e. Lat: 23° 11’ 24.67503’’ S

Long: 118° 46’ 6.15742’’ E

Can anyone help me please?

share|improve this question

closed as too localized by whuber Mar 11 '13 at 21:26

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Which UTM Zone are you working with? – Mapperz Jun 5 '12 at 13:36
Exactly what results do you get in the conversion back to lat/lon? In the example you give it appears the reconversion is perfect. – whuber Jun 5 '12 at 15:16

first of all pls check out your accept rate for users..

in excel cell formating can gives you wrong result... use to develop your own code for conversion.

for converting dms to ll:

function DMStoLL(degrees, minutes, seconds){
   return degrees + minutes / 60 + seconds / 3600

for converting ll to dms:

function LLtoDMS(coord){
   var d = parseInt(coord);
   var md = Math.abs(coord - d) * 60;
   var m = parseInt(md);
   var sd = (md-m) * 60;
   return [d, m, sd.toFixed(9)];

and you can get more information here Converting UTM to Latitude and Longitude (Or Vice Versa)

for utm, you can calculate your clicked zone as sth....

var clicked = map.getLonLatFromViewPortPx(evt.xy).transform(map.projection, 

var zone = (clicked + 186) / 6;

you have to calculate your n,e with your utm zone. if you tell us i can give some formule too..

i hope it helps you...

share|improve this answer
UTM zone should be 50S (Western Australia). You have to consider that you are in the southern hemisphere, so North lat should probably be negative, and UTM North zero is at the south pole. – AndreJ Mar 11 '13 at 16:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.