Copying all the data in a cell.

[eechristaylor]

I have a cell on one sheet that is calculating a cost, i.e. $4,568.50. I want to bring that data to another cell on anther sheet and have been using the formula ="Affect to Project Cost: Cost INCREASED by $"&Cost!R46
But the value it returns is: Affect to Project Cost: Cost INCREASED by $4568.5 and does not include the ZERO or the comma. I have tried to use ROUND, and also changed the Format of the cell but i can't get it to bring the 0 or teh comma over from that cell.
I am sure it is something simple i am missing but i just cant find it.
Any help is appreciated.

 

[Fluff]

Try

="Affect to Project Cost: Cost INCREASED by $"&TEXT(Cost!R46,"$#,##0.00")

 

[eechristaylor]

Try

="Affect to Project Cost: Cost INCREASED by $"&TEXT(Cost!R46,"$#,##0.00")

PERFECT, THANKS, I knew would be something simple I overlooked, I did look at this option but didnt inlcude the last statement in your formula. THANKS

 

[Fluff]

You're welcome & thanks for the feedback.