Concatenate with currency w/2 decimal places

  • Thread starter Thread starter Excel
  • Start date Start date
E

Excel

I'm working on a formula that is removing my currency formatting. =IF
(C31=$A$2,$D$2,"$")&IF(C31=$A$3,$D$3,"$")...

I've managed to get the "$" to the front of the figure but I'm getting
a result of four decimal places, $12.1245.
If I use "$0.00" instead of "$" alone the result is $0.0012.1245. =IF
(C31=$A$2,$D$2,"$0.00")&IF(C31=$A$3,$D$3,"$0.00")
I've also tried =IF(C31=$A$2,$D$2,"#.##")&IF(C31=$A$3,$D$3,"#.##")
with the result of an error.

I know I must be doing something wrong or missing something.

Any help would be greatly appreciated.

Thank you!

Cassandra
 
Let's start at the beginning
Please give us some examples of that data you have in the cells
It sounds as if you have text and you want to convert it to numbers
Generally we do not add the currency symbol but tell Excel to do this by
formatting
So a cell might have the VALUE 123.45 (and this would display in the Formula
Bar) but it might DISPLAY as $123.45

Sorry if I have totally misread your problem
best wishes
 
Back
Top