Concatenate and Format of result...

B

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
 
B

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

Dave Peterson

You can use:

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

or just use the & operator

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How specify number format of cell value in concatenate function? 1
gather data in selected cells and transfer value to another cell 1
Concatenate numbers and text while holding a custom number format. 9
Format numbers returned in the function CONCATENATE 3
concatenate and format 1
Concatenate and maintain format of original cells 2
#VALUE 1
Concatenate character fiels and/or report format 1

Top