Changing dates to text using VBA & deleting a column

Hi.
I have a problem that I want to use VBA to solve but I'm still learning VBA and can't figure it out.
So the problem is:
I have a column of variable length (rows) of dates (example "3/14/2012") which must be altered to the following format: 20120314. Secondly this number must then be converted to text.

I've tried manipulating a recorded macro, but no luck.
Hoping someone with more insight can help me out?
I've attached an example sheet.

Thank you advance.