I am having trouble using the CONCATENATE FUNCTION with a particular date format. The cell in question is A2, which is a date in the format YYMMDD. Here are the contents of the worksheet:

A1: AAPL
A2: 170329
A3: C
A4: 00120
A5: 000

I am attempting to merge the contents of A1:A5 in cell A6 so that it reads "AAPL170329C00120000". When I do this using the CONCATENATE function the date in A2 reads as some random number. I've tried messing around with the TEXT function, but I cannot get it to read as I'd like. Any thoughts?