Converting date to text
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.
|