Longitude and Latidude Formatting
 

I imported a text file with latitude and longitude cordinates into an excel
spreadsheet. The longitude and latitude came in as DD and not DMS like I had
planned. I read some other posts on how to fix this and tried them but it
didnt seem to work. When I formatted the cell in [hh]°mm'ss\" it came out as
#######.... I figured this was because it had a negitive sign in front of my
number. I removed the sign and tried again and got a totally different
number. Ive tried about everything I could think of. If any ones knows how to
fix this please let me know

Longitude and Latidude Formatting
 

The best I can do is send you to Chip Pearson's site

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


Gord Dibben MS Excel MVP

On Wed, 2 Jul 2008 15:52:01 -0700, Slightly Confused <Slightly
wrote:

I imported a text file with latitude and longitude cordinates into an excel
spreadsheet. The longitude and latitude came in as DD and not DMS like I had
planned. I read some other posts on how to fix this and tried them but it
didnt seem to work. When I formatted the cell in [hh]°mm'ss\" it came out as
#######.... I figured this was because it had a negitive sign in front of my
number. I removed the sign and tried again and got a totally different
number. Ive tried about everything I could think of. If any ones knows how to
fix this please let me know

Longitude and Latidude Formatting
 

Thank you, I've tried this site but I'll go over it again to see if I can get
something more out of it.

"Gord Dibben" wrote:

The best I can do is send you to Chip Pearson's site

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


Gord Dibben MS Excel MVP

On Wed, 2 Jul 2008 15:52:01 -0700, Slightly Confused <Slightly
wrote:

I imported a text file with latitude and longitude cordinates into an excel
spreadsheet. The longitude and latitude came in as DD and not DMS like I had
planned. I read some other posts on how to fix this and tried them but it
didnt seem to work. When I formatted the cell in [hh]°mm'ss\" it came out as
#######.... I figured this was because it had a negitive sign in front of my
number. I removed the sign and tried again and got a totally different
number. Ive tried about everything I could think of. If any ones knows how to
fix this please let me know