View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mgville Mgville is offline
external usenet poster
 
Posts: 7
Default 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.