concatenate a date

[ibeetb]

I need to concatenate a date with a text value without the date being turned
into a serial number.....EX:
if 8/26/2003 is in A1 and "John Doe" is in A2, when =concatenate(a1,a2), I
get '37828John Doe" but what I need is 8/26/2003John Doe

I am doing this in code, by the way and it is being reflected in my
worksheet

 

[Niek Otten]

=CONCATENATE(TEXT(A1,"mm/dd/yyyy"),A2)