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

"Northcoast" wrote:

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 #")

Whe F2, H2 and J2 are fractions.

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