| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for concatenating text with results from calculation
Thank you! Perfect!
"joeu2004" wrote: On Feb 13, 6:30 am, Mgville wrote: ="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. Use the TEXT function. Examples: ="FY 2009 budgeted cases are " & TEXT(E28,"#,###") ="a decrease of " & TEXT(F28/E27,"#.00%") HTH. ----- original posting ----- On Feb 13, 6:30 am, Mgville wrote: 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. |
| Reply |
| 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) | |||
Hybrid Mode
