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.

=DATEVALUE(A1), where cell A1 contains the text in question. format the
result in any date format you want.

"Jordan" wrote:

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.

Thank you very much.

"Rob" wrote:

=DATEVALUE(A1), where cell A1 contains the text in question. format the
result in any date format you want.

"Jordan" wrote:

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.