Concatenate with currency w/2 decimal places
 

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

Concatenate with currency w/2 decimal places
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Excel" wrote in message
...
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