+ Reply to Thread
Results 1 to 3 of 3

Showing Degrees correctly in cells for aviation application

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Showing Degrees correctly in cells for aviation application

    Hi - newbie here

    I need to show degrees correctly in an excel doc. So far, I have learned that =MOD(M3,360) will keep the number of M3 within 360 degrees. This is great, but if M3 was 370, the formula would return 10. Now this is good, but I need it to show 010 instead. This is how the aviation community refers to degrees when we fly. So basically, anything up to 99 need to return with either 1 or 2 zero's in front of it (9 would be 009).

    Can anyone advise me how to achieve this?

    Much appreciated....

    Mark

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Showing Degrees correctly in cells for aviation application

    You can use custom number format as 000 in the formula cell.
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Registered User
    Join Date
    04-05-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Showing Degrees correctly in cells for aviation application

    FANTASTIC - thanks so much for replying. It works!....much appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1