Date column changed to number format while concatenating
 

Hi

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

Date column changed to number format while concatenating
 

="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.