Date column changed to number format while concatenating

B

Biju Jacob

Hi

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

Bob Phillips

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

or similar

--

HTH

Bob Phillips

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