Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 # |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |