Number format question

[Joker]

I have the following formula:

="*First year estimated home sales of "&C35&" with 15% growth rate in
subsequent years."

I want to have this statement adjust to changes made in the number (C35).
However, this is what the phrase looks like:

*First year estimated home sales of 67188 with 15% growth rate in subsequent
years.

How can I get the number to format show the comma?

 

[Dave Peterson]

="*First year estimated home sales of " & text(C35,"#,##0") &
" with 15% growth rate in subsequent years."

 

[Joker]

Hello, Dave!

That did it. Your a genius.