CONCATENATE Cells Formated as fractions
 

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 #

CONCATENATE Cells Formated as fractions
 

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 #

CONCATENATE Cells Formated as fractions
 

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!
================================================== ===

"Northcoast" wrote in message
...
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 #

CONCATENATE Cells Formated as fractions
 

Thanks, that worked.

"RagDyeR" wrote:

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!
================================================== ===

"Northcoast" wrote in message
...
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 #

CONCATENATE Cells Formated as fractions
 

Appreciate the feed-back.
--

Regards,

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

"Northcoast" wrote in message
...
Thanks, that worked.

"RagDyeR" wrote:

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!
================================================== ===

"Northcoast" wrote in message
...
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 #