I am assuming 01 is your month, so it would be

=DATE(LEFT(A1,4),LEFT(RIGHT(A1,4),2),RIGHT(A1,2))

if 01 is your day, then

=DATE(LEFT(A1,4),RIGHT(A1,2),LEFT(RIGHT(A1,4),2))

Then format the date to what you want.

"jjackson97" wrote:

I have an Excel worksheet that has dates entered as General format like the
following: 19970103

I am trying to convert these to dates (MM/DD/YYYY), but everything I try
does not work.

Any help is greatly appreciated!