| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
I am using the following formula:
=CONCATENATE(Sheet1!B2,"(",Sheet1!B15,")") The reference cell, "Sheet1!B15", is formatted as a percentage. The output that I get from this formula is: "4(0.0615384615384615)" How do I get the "0.06..." to come out as 6% so it looks like this: "4(6%)" Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate
=CONCATENATE(Sheet1!B2,"(",TEXT(Sheet1!B15,"0%")," )")
-- Gary''s Student - gsnu200817 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate
A little more compact...
=Sheet1!B2&TEXT(Sheet1!B15,"(0%)") -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... =CONCATENATE(Sheet1!B2,"(",TEXT(Sheet1!B15,"0%")," )") -- Gary''s Student - gsnu200817 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate/ Min-Max | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| CONCATENATE | Excel Worksheet Functions | |||
| CONCATENATE | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Linear Mode
