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


In article ,
Dave wrote:

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....(go
es 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