Excel: Changing Format of Odd Date Field

I have a download that posted dates in a way that are hard to read and hard to sort. The cell on the left is how it looks in the download and I would like to make it look like the date on the right. Could anyone help? Much appreciated, Eric

20141015 10/15/2014

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of December 16, 2014.

For more resources for Microsoft Excel