Use the TEXT function to create the format...

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

--
Rick (MVP - Excel)


"ogerriz" wrote in message
...
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?