Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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!!!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"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. |
#3
![]() |
|||
|
|||
![]() Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate with currency w/2 decimal places | Excel Programming | |||
Currency formula | Excel Worksheet Functions | |||
lookup formula for currency | New Users to Excel | |||
Currency Formula | Excel Discussion (Misc queries) | |||
How do I concatenate two currency cells to show a price range? | Excel Worksheet Functions |