Formula for concatenating text with results from calculation

[Mgville]

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.

 

[joeu2004]

="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 -----

 

[Mgville]

Thank you! Perfect!

Use the TEXT function. Examples:

="FY 2009 budgeted cases are " & TEXT(E28,"#,###")

="a decrease of " & TEXT(F28/E27,"#.00%")

HTH.


----- original posting -----