Excel: Formulas for feet and inches

[RebeccaR]

I am trying to combine 2 cells in excel. I have feet in column Hand inches(fraction form) in column I. I want to combine these two cells in column M and have it display feet and inches in fraction form.

*I do not want to round.

I have tried to use this formula that i found on the web but it does round(Hence the ROUND that didn't register in my head when typing)
=INT(H4)&"'-"&ROUND(((I4-INT(I4))*12),0) & CHAR(34)

I have also tried concatenation but that displays the inches in a decimal.
=CONCATENATE(H4,"-",I4)

I appreciate any help that someone can give. Thank you!

 

[njimack]

=h4&"-"&i4*12

 

[GR00007]

=h4&"-"&text(i4,"#?/?") <-- this will round
=H4&"-"&TEXT(I4,"#??/??") <-- this will also round, but will be more precise, I didn't know how many digits your data goes to - you can try both to see which you prefer

 

[BGY23]

[TABLE="width: 143"]
<colgroup><col width="190" style="width: 143pt; mso-width-source: userset; mso-width-alt: 6948;"> <tbody>[TR]
[TD="width: 190, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
=F5&" - "&text(G5,"# ??/??")

Change your cell address to fit. Itdoesn' matter hat your inches cell iindecimal

 

[RebeccaR]

=h4&"-"&text(i4,"#?/?") <-- this will round
=H4&"-"&TEXT(I4,"#??/??") <-- this will also round, but will be more precise, I didn't know how many digits your data goes to - you can try both to see which you prefer

for example my first set of data is:
H4 = 39
I4 = 7 11/16

I want M4 to say 39' - 7 11/16"


I tried the formula above and it gives me 39-123/16.

Thank you!

 

[Fluff]

Hi & welcome to the board
Try
=H4&"' - "&TEXT(I4,"# ??/??")&CHAR(34)

 

[RebeccaR]

Hi & welcome to the board
Try
=H4&"' - "&TEXT(I4,"# ??/??")&CHAR(34)

This is perfect. Thank you.

One more question: Is there a way to convert this number to a decimal? I was just told I need both.

 

[Fluff]

How about
=H4+(I4/12)

 

[RebeccaR]

How about
=H4+(I4/12)

Thank you for all your help!!

 

[Fluff]

You're welcome