Unable to CONCATENATE date with text

[Rehaan Syeed]

Hi

Mr.Excel Team

I am unable to CONCATENATE the cells consists of date with the cell consists of text.

when iam CONCATENATE but the cells the text is appearing but the date is coming in a number format

can you help me with that

thanks

Rehaan syeed

 

[VoG]

Try like this

=A1&TEXT(B1,"dd/mm/yyyy")

where B1 holds a date.