View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Concatenate, currency & sum formula

"mcoker1" wrote:
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),"*")

[....]
This does not have a "," and it would not have a $ if I would have not
added it. Thanks!!!!


One way:

=D25+C26

formatted as Custom $#,##0.00\* . That preserves the numeric type of the
cell, so you can still reference in other formulas.

Alternatively, if you want a text result:

=TEXT(D25+C26,"$#,##0.00\*")

perhaps formatted with Right Horizontal Alignment.

Use SUM(D25,C26) instead of D25+C26 only if D25 or C26 might contain
(non-numeric) text, and you want to avoid a #VALUE error in that case.