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