concatenating formulas and getting thousand separators

Chelrie

New Member
Joined
Jul 14, 2009
Messages
27
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!")
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.
 
Upvote 0
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
Code:
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.
 
Upvote 0
excel tells me that there are too many arguments to use the text function...any other ideas??
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top