Combine date with another number in another cell?

Originally Posted by ChemistB

with Date in A1 and Serial Number in A2
=Text(A1,"mmddyy")&RIGHT(A2,3)
Is that what you need?

This is exactly how I wanted it! now is there a way to automatically apply this formula to the whole column?