| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for concatenating text with results from calculation
Hello, my original looks like
FY 2009 budgeted cases are 11,000, a decrease of 10,881 cases of actual volume I would like to incorporate the results of the calculated field, in the right format, into my text statement. ="FY 2009 budgeted cases are "& E28& ", a decrease of" &F28& " cases of actual volume" ...this works but I need the numerical results to have a comma in it.....also I have another one that needs to look like a percentage. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a conditional formula that results in another calculation | Excel Worksheet Functions | |||
| Calculation results as static data not formula. | Excel Worksheet Functions | |||
| Need to export to text results not formula | Excel Discussion (Misc queries) | |||
| add space between the results of a formula and text | Excel Discussion (Misc queries) | |||
| Concatenating text | Excel Discussion (Misc queries) | |||
Threaded Mode
