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