I am dumping some information out of our ERP system into Excel. Within our ERP system the date is written as 20130129. Excel views this as a text field. I need to covert this to a date format and have the date be shown as 01/29/2013. Any suggestions on how to do this?