O
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?
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?