| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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"
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| Excel: how to convert "27.11.2007 15:13" to number (cellformat fai | Excel Discussion (Misc queries) | |||
| convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
| function to convert number to words [ 21 = "twenty one " ] | Excel Worksheet Functions | |||
| How can I convert a Number into words. Ex: "10" as "Ten" | Excel Worksheet Functions | |||
Linear Mode
