CONCATENATE with decimals, convert to fractions

Originally Posted by rberger909

Ok I am using CONCATENATE in the following way "=CONCATENATE(AB96,"-",AD96)"

cell AB96 is a measurement in feet and AD96 is a measurement in inches...therefore if AB96 was 8 and AD96 was 1 1/2 the CONCATENATE cell reads 8-1.5

However I want the CONCATENATE cell to read 8-1 1/2, not 8-1.5...changing the format of the cell to fraction doesn't help either...any help?

Try again,

something like

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

hth
---

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.

---