Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retain decimal places in a concatenate function | Excel Programming | |||
Currency Formatting to 3 decimal Places | Excel Programming | |||
decimal places in currency | Excel Programming | |||
variable as Currency two decimal places | Excel Programming | |||
Text Box Currency format with two decimal places | Excel Programming |