CONCATENATE Cells Formated as fractions

[Northcoast]

I want to concatenate several cells, some of which are formated as fractions,
and have it display those numbers as a fraction. When I perform the
function, it displays the cell in its decimal form.

Example:
=CONCATENATE(E2," ( ",F2," in. "," ",G2," ",H2," in. ", I2," ",J2," in."," )
"," color #")

Where: F2, H2 and J2 are fractions.

Result: 12" Stretcher ( 11.625 in. x 23.625 in. x 3.625 in. ) color #

 

[bpeltzer]

Use the text function to specify to Excel how you want the numbers formatted.
Where you have F2, use TEXT(F2,"#/#"), etc.

 

[RagDyeR]

Try this:

="( "&TEXT(F2,"# #/##")&" in. x "&TEXT(H2,"# #/##")&" in. x "&TEXT(J2,"#
#/##")&" in. ) color # "

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I want to concatenate several cells, some of which are formated as
fractions,
and have it display those numbers as a fraction. When I perform the
function, it displays the cell in its decimal form.

Example:
=CONCATENATE(E2," ( ",F2," in. "," ",G2," ",H2," in. ", I2," ",J2," in."," )
"," color #")

Where: F2, H2 and J2 are fractions.

Result: 12" Stretcher ( 11.625 in. x 23.625 in. x 3.625 in. ) color #

 

[Northcoast]

Thanks, that worked.

 

[RagDyeR]

Appreciate the feed-back.