Concatenate Help

[slinkyjib]

Good morning,
I'm trying to do a simple concatenate formula, but I'm having a problem.
The formula I am using is below;

=CONCATENATE("TYPE: ",R2," SIZE: ",T2," SUPPLIER: ",X2," UNIT PRICE: ",U2," BIN NUMBER: ",W2)

This formula works, but in cell U2, I have a currency value.e.g. 1.00 or 2.50
When the formula concatenates it puts the value of U2 in as 1 or 2.5
Is there anyway to get it to display the vaule of the cell including the zero's?

Even tried the old "" but then I just get U2 in the concatenated formula...

any help appreciatted.

oh and merry xmas all.......

 

[Richard Schollar]

Try this:

=CONCATENATE("TYPE: ",R2," SIZE: ",T2," SUPPLIER: ",X2," UNIT PRICE: ",TEXT(U2,"0.00")," BIN NUMBER: ",W2)

Regards

Richard

 

[slinkyjib]

you're a star, thanx for that...