I would like to create a unique ID by combining Name & birthday.

For : Abc Def birthday 1/1/08

I would like it to read ADef010108. I can get everything in, except the
date is always formated into serial number. is there anything i can do to
make it the way i want it? Thank you.

Use
Text(A1,"mmddyy") in your formula

like
=B1&Text(A1,"mmddyy")
if A1 has date and B1 has ADef

"ac" wrote:

I would like to create a unique ID by combining Name & birthday.

For : Abc Def birthday 1/1/08

I would like it to read ADef010108. I can get everything in, except the
date is always formated into serial number. is there anything i can do to
make it the way i want it? Thank you.

Assuming:
A1: holds Abc Def
B1: holds Date

=LEFT(A1)&MID(A1,FIND(" ",A1)+1,99)&TEXT(B1,"mmddyy")


"ac" wrote:

I would like to create a unique ID by combining Name & birthday.

For : Abc Def birthday 1/1/08

I would like it to read ADef010108. I can get everything in, except the
date is always formated into serial number. is there anything i can do to
make it the way i want it? Thank you.