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'