Longitude /Latitude

T

Taurus

I would like to know the break down on the Longitude and Latitude in my
spreadsheet for US region if anyone could explain it?
Longitude: -104:02:09.20
Latitude: 46:03:07.42

I have no clue where to start and longitude has the negative value.

In Spreadsheet is in the Text field format as DDDD:MM:SS:SS. I am not
allow to change the format in the spreadsheet.
Longitude: -104:02:09.20
Latitude: 46:03:07.42

How could I convert it to proper format in IO object in VBA?
Please advise. Thank you in advance
 
T

Tom Stiller

Taurus said:
I would like to know the break down on the Longitude and Latitude in my
spreadsheet for US region if anyone could explain it?
Longitude: -104:02:09.20
Latitude: 46:03:07.42
Click to expand...

104 degrees, 2 minutes, 9.2 seconds west latitude;
46 degrees, 3 minutes, 7.42 seconds north latitude
I have no clue where to start and longitude has the negative value.
Click to expand...
Any longitude west of the Greenwich meridian is negative as is any
latitude south of the equator.
In Spreadsheet is in the Text field format as DDDD:MM:SS:SS. I am not
allow to change the format in the spreadsheet.
Longitude: -104:02:09.20
Latitude: 46:03:07.42

How could I convert it to proper format in IO object in VBA?
Please advise. Thank you in advance
Click to expand...

What do you mean by "proper" format? You can represent it as degrees
and fractions of a degree if you do the arithmetic
 
J

JE McGimpsey

Taurus said:
I would like to know the break down on the Longitude and Latitude in my
spreadsheet for US region if anyone could explain it?
Longitude: -104:02:09.20
Latitude: 46:03:07.42

I have no clue where to start and longitude has the negative value.

In Spreadsheet is in the Text field format as DDDD:MM:SS:SS. I am not
allow to change the format in the spreadsheet.
Longitude: -104:02:09.20
Latitude: 46:03:07.42

How could I convert it to proper format in IO object in VBA?
Please advise. Thank you in advance
Click to expand...

Not sure what you mean by "proper format". You may want to take a look
here:

http://cpearson.com/excel/latlong.htm
 
Top