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

=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)

"Brad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>

You can use:

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

or just use the & operator

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



Brad wrote:
>
> 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

--

Dave Peterson