Hi
in one column enter the formula as follow
=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,1,1)),VALUE(R IGHT(A1,1)))

"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!