Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    latitude longitude (Excel 97)

    Is there a built-in format or function to handle degrees, minutes, and seconds associated with latitude and longitude?
    Ideally I could input the decimal values and have it display as deg/min/sec.

    (I know that I can set up equations to do the conversion)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: latitude longitude (Excel 97)

    As far as I know there is nothing builtin.
    I also do not think it would be possible to have a custom format to display.

    This means that if you do "convert" the number to "look" like degrees/min/secs (excel formula or a a user dedined function). This converted "number" will be text and you will have to keep the original number if you want to do any mathematical manipulations with the numbers.

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: latitude longitude (Excel 97)

    Perhaps you could use an adaption the the TIME Format as follows :

    <big>[hh]

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: latitude longitude (Excel 97)

    Andrew,
    Good answer. I wish I had thought of that before I had responded originally.

    I also found a Chip Pearson discussion on this topic.

    Steve

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: latitude longitude (Excel 97)

    Thanks for the link to that. It corrected the suggestion of Alt 0186, which I mistakenly took as the degree sysmbol. A quick check confirms that Alt 0176 is the correct character.

    Andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •