HOW TO STOP DATES CHANGING TO NUMBERS WHEN CONCATENING

[KITSONA]

I am wanting to concatenate and include a date, the dates change to a series of number, instead of staying in the date formate.

For example, the date format should be 200205 (yymmdd). When I concatenate it changes to 43866.

Any suggestions please?

[#2]

@KITSONA 

Assuming your text is in A1 and the date is in B1, this formula works

=A1&" "&TEXT(B1,"m/d/y")

[#3]

Brilliant. Thanks so much. It has worked!!

@mathetes