Format Decimal values!

Hi!

I am using MS Office 2007


I have values:

A1= 703,102.40
B1= AND
C1= 23
D1= %

EI= (I need result as: 703,102.40 AND 23 %)

But when i CONCATENATE, I get : 703,102.4 AND 23 % (.4 - [zero is missing])

Please help me out - so that it displays 2 decimals even if its 'Zero'

Please use the following formula in C1 considering you have the numbers in A1 & B1

=CONCATENATE(TEXT(A1,"##,###.00")," AND ",TEXT(B1,"##%"))

Or, If you have

A1= 703,102.40
B1= AND
C1= 23
D1= %

in E1:

=CONCATENATE(TEXT(A1,"##,###.00")," ",B1," ",C1,D1)