eechristaylor
New Member
- Joined
- Oct 22, 2013
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
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.
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.