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
Bookmarks