how to convert number to bearing .exp. 40.4040 to 40d 40' 40"
M melz Nov 22, 2008 #3 JE McGimpsey said: One way: A1: 40.4040 B1: =TEXT(A1*1E4,"0\d 00\' 00\""") thank . JE McGimpsey. Click to expand...
JE McGimpsey said: One way: A1: 40.4040 B1: =TEXT(A1*1E4,"0\d 00\' 00\""") thank . JE McGimpsey. Click to expand...