concatenating formulas and getting thousand separators

[Chelrie]

I'm trying to get thousand separators to show up in my formula...the original cell (B11) has them, but they don't show up in the text result of the concatenation. HELP!

=CONCATENATE("The two-way average traffic for your location is ",'Ad Calculator'!B11," vehicles. That's ",'Ad Calculator'!B11*30," per month, and ",'Ad Calculator'!B11*365," per year. Assuming 4 out of every 10 cars has a passenger, that's ",('Ad Calculator'!B11*365)*1.4," exposures per year!")

 

[snowblizz]

Look at the TEXT() function. Something like this.
TEXT('Ad Calculator'!B11*365, dateformat)

Now I don't remember exactly the syntax for "dateformat", but you should find that in the help. Or look at the cell you are referring to.

 

[snowblizz]

Look at the TEXT() function. Something like this.
TEXT('Ad Calculator'!B11*365, dateformat)

Now I don't remember exactly the syntax for "dateformat", but you should find that in the help. Or look at the cell you are referring to.

Had a quick look and

TEXT('Ad Calculator'!B11*365, "0 %")

will format as percentages, as an example.
To find the one you use check cell B11. Format Cells, look at the "custom" tab and it will show the current format in use, copy that into the TEXT() function.

 

[PA HS Teacher]

I believe you want to use something of the form:
=Text(A1,"#,#")

 

[Chelrie]

excel tells me that there are too many arguments to use the text function...any other ideas??