Im doing a mail merge and a date that I would like to merge to my letters is found in 2 different columns on my .csv data sheet. Column A has mm/dd and shows 1106 for November 6th and Column B has yy and shows 7 for 2007. The data is formatted as a number when I format the 1106 to a date it shows 1/10. Is there a formula to take the data from both cells and format it to show 11/06/2007? I'm using Excel 2000 and XP.