concatenate a date
 

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

concatenate a date
 

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

--
Regards,

Niek Otten
Microsoft MVP - Excel

"ibeetb" wrote in message
...
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