Concatenate with currency w/2 decimal places

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Out of Memory Message - Code Problem? 4
Formatting strings 5
Excel Concatenate with line breaks but ignore blank cells 3
VBA code outputs currency value rounded to 2 decimal points 7
Access stripping decimal places in query 1
Scrabble Value calculation for Welsh words 0
Round to 2 decimal places 2
Help! creating code for time to decimal calculations 1

Top