How to convert exported text date to desired date format with excel vba.

Hello ExcelForum Members,

I am exporting some data form a text file (.txt) to excel sheet. One of the column contains the date like 20130704 (yyyymmdd). When I click on any of cells containing the date values, it shows the general datatype. What I am trying to do is to convert these dates in general data type format to date data type so that I can use these dates in calculations. I want it to be done with the help of vba because the size of exported data varies. So I want to make sure that once the vba code is executed, it converts all the values in that column until the last row.

Is there any way to do this?
Any help would be appreciated.
Thanks in advance.

sktneer