Concatenating date field does not work for me

[squirtguns]

Example<br>
<br>
Cell A1 =2/16/2000<br>
Cell A2 =John<br>
Cell A3 contains the following formula=A2&&quot; &quot;&A1<br>
<br>
The result is displayed as john 36572<br>
<br>
How could I get this to display as John 2/16/2000?<br>
<br>
thanks<br>

 

[Neddy]

Put the following formula in Cell A3:<br>
<br>
=A2&&quot; &quot;&TEXT(A1,&quot;dd/mm/yyyy&quot

 

[Neddy]

Sorry, I used UK date format. You need to put:<br>
=A2&&quot; &quot;&TEXT(A1,&quot;mm/dd/yyyy&quot