Concatenate, currency & sum formula
I am using the concatenate function to add an asterisk at the end of a currency formula in a cell but it is not recognizing the currency. My formula is below:
=concatenate("$",sum(d25,c26),"*")
My answer in the cell is $102387327.45
This does not have a "," and it would not have a $ if I would have not added it. Thanks!!!!
|