ExcelBanter - how to convert number to bearing .exp. 40.4040 to 40d 40' 40"

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to convert number to bearing .exp. 40.4040 to 40d 40' 40" (https://www.excelbanter.com/excel-worksheet-functions/211115-how-convert-number-bearing-exp-40-4040-40d-40-40-a.html)

melz

how to convert number to bearing .exp. 40.4040 to 40d 40' 40"

how to convert number to bearing .exp. 40.4040 to 40d 40' 40"

JE McGimpsey

how to convert number to bearing .exp. 40.4040 to 40d 40' 40"

One way:

A1: 40.4040
B1: =TEXT(A1*1E4,"0\d 00\' 00\""")

In article ,
melz wrote:

how to convert number to bearing .exp. 40.4040 to 40d 40' 40"

melz

thank

"JE McGimpsey" wrote:

One way:

A1: 40.4040
B1: =TEXT(A1*1E4,"0\d 00\' 00\""")

In article ,
melz wrote:

how to convert number to bearing .exp. 40.4040 to 40d 40' 40"
thank . JE McGimpsey.

All times are GMT +1. The time now is 12:55 PM.