Concatenate and Format of result...

[Brad]

I have a simple formula that concatenate values from several cells:

=CONCATENATE(ROUND(D223,0), " ",ROUND(D224,0), " ",ROUND(D225,0), " on
",D227).

D223, D224 and D225 need 1000 comma separators in the result so that D223,
for example, would read 195,844 and not 195844 in the concatenated string.
As it is, these three cells do have the thousands separator format but the
format doesn't transfer to the concatenated result.

My thanks in advance for any suggestions here.

Cheers! Brad

 

[Bob Phillips]

=TEXT(ROUND(D223,0),"#,##0")&" "&TEXT(ROUND(D224,0),"#,##0")&"
"&TEXT(ROUND(D225,0),"#,##0")&" on "&D227

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

You can use:

=concatenate(text(round(d233,0),"#,##0"), " ", ....

or just use the & operator

=text(round(d233,0),"#,##0") & " " &....