Longitude /Latitude

[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

 

[Tom Stiller]

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

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.

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

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

 

[JE McGimpsey]

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

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

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