="Date is "&TEXT(A1,"dd mmm yyyy")

or similar

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Biju Jacob" wrote in message
...
Hi

While concatenating two cells i found that the date cell referred is
changed
to number format .Pls provide a solution.