I apoligize - I see what you mean. I changed the formula to read:

ActiveCell.FormulaR1C1 = "=RC[-11]&"";""&RC[-10]&"";""&RC[-9]&"";""&RC[-8]&"";""&RC[-7]&"";""&TEXT(RC[-6],""Short Date"")&"";""&TEXT(RC[-5],""Short Date"")&"";""&RC[-4]&"";""&RC[-3]&"";""&RC[-2]&"";""&RC[-1]"
...and now "7/1/2012" turned in to "00ort 1at2012". Should I change "Short Date" to "mm/dd/yyyy"?

Thanks