I have a date that is imported in to Excel at text and will not allow me to
reformat the date by using format cell.

It is shown as 2005/06/01 for May 6, 2004. I need a formula that will take
show the same date as mm/dd/yy.

Any help will be appreciated.

Thanks.