View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ac ac is offline
external usenet poster
 
Posts: 18
Default Converting date to text

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.