View Single Post
  #1   Report Post  
mcoker1 mcoker1 is offline
Junior Member
 
Posts: 2
Default 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!!!!