Longitude and Latidude Formatting

  • Thread starter Slightly Confused
  • Start date

S

Slightly Confused

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
 
Ad

Advertisements

Ad

Advertisements

S

Slightly Confused

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 said:
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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top