Converting date to text

  • Thread starter Thread starter ac
  • Start date Start date
A

ac

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
 
Assuming:
A1: holds Abc Def
B1: holds Date

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