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?

[TABLE="width: 505"]
<tbody>[TR]
[TD]Day
[/TD]
[TD]Net Amt
[/TD]
[TD]Currency
[/TD]
[TD]RATE
[/TD]
[TD] Interest
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD] 6,687,946.48
[/TD]
[TD]USD
[/TD]
[TD]3.5
[/TD]
[TD] 1,950.65
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]CONCATE Results:
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]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
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.