Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate formula or &
I am creating a text template in excel and I have the following 2
rows(combination of text, number and formula and %). please note that I changed the format of E1 to percentage with 2 decimal. To combine the following cells together: A1 | B1 | C1| D1 | E1 | F1 2 | Divided by | 3 | is | =(A1/C1) | percent i created this formula in cell A2: =A1&B1&C1&D1&E1&F1 and i get: 2 Divided by 3 is: .666666666666 percent and i want to get the following in one cell: 2 Divided by 3 is: 66.66% percent what should i do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with formating % in concatenate formula | Excel Discussion (Misc queries) | |||
I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
CONCATENATE formula | Excel Discussion (Misc queries) |