Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am combining 3 cells A1 B1 C1 with an x between them using this forumla:
=A1&" x "&B1&" x "&C1 A1's data is 07.00 (the entire column is formatted with Custom 00.00) B1's data is 02.12 (same format) C1's data is 02.12 (same format) My DESIRED result is to have column D1 to look like this: 07.00 x 02.12 x 02.12 My ACTUAL result is looking like this: 7 x 2.12 x 2.12 Any suggestions for a rookie? Thanks, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you set to default the # of decimal places in Format Cells? | Setting up and Configuration of Excel | |||
Keeping the format when referencing cells? | Excel Discussion (Misc queries) | |||
Keeping the format when referencing cells? | Excel Worksheet Functions | |||
Combining Cells BUT Keeping source formatting | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |