CONCATENATE with decimals, convert to fractions

Originally Posted by Bryan Hessey

Try again,

something like

=A1&"' "&INT(B1)&" "&IF(MOD(B1,1)=0,"",TEXT(INT(MOD(B1,1)*12)/12,"?/??"))&""""

hth
---

One more question...the formula works great BTW...right now the formula spits out something like 4' 10 1/2"...how do i get a dividing dash between the feet and inches...meaning how do I make 4' 10 1/2" appear as 4'-10 1/2"...small I know but driving me nuts.

Oh and my code was actually a roundup/rounddwon mix, not what you had...nonetheless simular idea I guess. Thanks again!


*EDIT* - Disregard I found it...thanks!!

Originally Posted by rberger909

One more question...the formula works great BTW...right now the formula spits out something like 4' 10 1/2"...how do i get a dividing dash between the feet and inches...meaning how do I make 4' 10 1/2" appear as 4'-10 1/2"...small I know but driving me nuts.

Oh and my code was actually a roundup/rounddwon mix, not what you had...nonetheless simular idea I guess. Thanks again!


*EDIT* - Disregard I found it...thanks!!

Hi,

the - was after the ' for the feet indicator, as you apparently found.

the question asked related to "the following way "=CONCATENATE(AB96,"-",AD96)" cell AB96 is a measurement in feet and AD96 is a measurement in inches" and did not seem to mention "a roundup/rounddwon mix" but as it needed to be twelths the formula given appeared to work, however you can add rounding (up/down/ceiling) as required.

Good to see it worked for you, and thanks for the response.

---