number formatting when used with the & " xxx"

[Trachr]

Is it possible to format a number you used in a cell similar to this:

="Total Expenses to Date: " & SUM(Table7[Actual
Total Costs])

It'll relay a line similar to Total Expenses to date: 111111

I would like that number to have the , in it so 111,111 I know I can accomplish that simply by using 2 cells, one for the text and one for the number however I am limited on space on the table which is why I combined the cells, now I just dont know how to format that number so it uses dividers or if its even possible.

Thanks.

[Norie]

You can use TEXT.

="Total Expenses to Date: " & TEXT(SUM(Table7[Actual

 Total Costs]), "###,##0")

[Trachr]

Thank you, that worked perfectly