format a number appearing in a text formula

[ogerriz]

Col A B C D
OI 1,150 1,000 OI = 2150
DC 3,900 4,500 DC = 8400

I have the following info in the first 3 columns then in the column D I have
the formula =A2&" = "&(b2+c2) which gives me the item being displayed as
above. I am using it for text boxes in a chart so I need to show the item in
D to read:

OI = 2,150
DC = 8,400

Is there a way I can apply formats to a formula or would I have to go:
use concantenate & truncate to put the commas in the correct places?

 

[Rick Rothstein]

Use the TEXT function to create the format...

=A5& "= "&TEXT(B5+C5,"#,###")

 

[Jacob Skaria]

Formula in D2

=A2& " = "&TEXT(B2+C2,"0,0")

If this post helps click Yes