Pecoflyer is absolutely correct.
To be really sure of a good result, makes sure to choose the date format in the 3rd step of the Text to Columns wizard, to match that of the source data (not what you want it to become). Once that's done, the cells will have Excel dates in and you'll be able to apply any format you choose to want to see them in: