Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 # |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 # |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 # |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 # |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 # |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
Concatenate custom cells | Excel Discussion (Misc queries) | |||
Concatenate Multiple Cells | Excel Discussion (Misc queries) | |||
Concatenate cells in Pocket Excel | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |