Format CONCATENATE

[Dave]

i am trying to format the result of a concatenate equation so that it may
have 2 decimal places. There is no trouble with the function itself just
formatting.

the equation is:

=CONCATENATE(IF(AND(AW$7>=$E12,AW$7<=$H12),(($D12*$I12)/$J12/40),""),IF....(goes on for 12 more times with different criteria and references)

Where
AW7,E12,and H12 are dates (dd/mm/yy)
D12 and J12 are numbers (no formating)
I12 is a percent (no decmials)

thanks

 

[Duke Carey]

try substituting

TEXT(($D12*$I12)/$J12/40,"##.00")

for

($D12*$I12)/$J12/40

within the body of your formula

 

[JE McGimpsey]

No need to start a new thread... See one answer at your previous thread.

 

[bj]

if you want two decimal places you might try
....text(40*($D12*$I12)/$J12,".00")...to replace ), (($D12*$I12)/$J12/40)