How to keep format of a number cell when concatinating multiple references?

[Annabel_in_CA]

Hello,
I'm trying to concatenate a few cells so I can use the string in a word document without retyping numbers.
Could someone show me how to keep the conditional format of accounting format numbers in the concate results?

Day	Net Amt	Currency	RATE	Interest
3	6,687,946.48	USD	3.5	1,950.65
CONCATE Results:
Calculation: USD 6687946.48 x 3.5% x 3 days / 360 = USD 1950.65 Would like to see this instead: Calculation: USD 6,687,946.48 x 3.5% x 3 days / 360 = USD 1,950.65 Thank you in advance! Annabel

<tbody>
</tbody>

 

[jtakw]

Hi,

I believe this is what you want:

Book1
	A	B	C	D	E	F	G
1	Day	Net Amt	Currency	RATE	Interest		Result
2	3	6,687,946.48	USD	3.5	1,950.65		Calculation: USD 6,687,946.48 x 3.5% x 3 days / 360 = USD 1,950.65
Sheet19

Cell Formulas
Range	Formula
G2	="Calculation: "&C2&" "&TEXT(B2,"0,0.00")&" x "&D2&"% "&"x "&A2&" days / 360 = "&C2&" "&TEXT(E2,"0,0.00")

 

[Annabel_in_CA]

Thank you jtakw! I needed the TEXT function!

 

[jtakw]

You're welcome.