decimal feet to feet-inch-sixteenths conversion

[tv]

i am trying to write a formula in excel, without using VB/macros, that will
convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)

can anyone help me with this

[Doug Kanter]

"tv" <tv@discussions.microsoft.com> wrote in message
news:36889905-0221-48C6-9A06-A00A151D1088@microsoft.com...
>i am trying to write a formula in excel, without using VB/macros, that will
> convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)
>
> can anyone help me with this

Several people answered this question when you posted it earlier.

[mphymel]

These will detect a negative result, assume your decimal value is in Cell L11....

This will display as 2' 5-7/16"
=IF(AND(L11<0,TRUNC(L11)=0),"-","")&TRUNC(L11)&"' "&TRUNC(12*MOD(L11,1))&"-"&TRUNC(16*MOD((12*MOD(L11,1)),1))&"/16"&CHAR(34)

This will display as F-I-S
=IF(AND(L11<0,TRUNC(L11)=0),"-","")&TRUNC(L11)&"-"&TRUNC(12*MOD(L11,1))&"-"&TRUNC(16*MOD((12*MOD(L11,1)),1))

[FlameRetired]

Withdrawn by FR