Concatenate

[atuljadhav]

Dear Sir

A1 Having Date "18-Aug-2011"

B1 Having "Total of"

Now i want to combine both using Concatenate formula

=CONCATENATE(B1," ",A1) but it show as

"Total Of 40773"

pl give me solution

 

[Michael M]

Try

=B1&" "&TEXT(A1,"dd-mmm-yyyy")