Text string to Date

[jkgreen]

I get a data file each month that has four date columns. These date columns are formatted as text fields and are shown as 20110201 for Feb 1, 2011. I want to convert the string to display as 02/01/2011. I am currently import the file into Access and exporting back out to Excel. Is there an easier way to make the conversion in Excel only?

 

[njimack]

=date(left(a1,4),right(a1,2),mid(a1,5,2))

 

[Andrew Poulsom]

Try Data|Text To Columns specifying data YMD at Step 3.

 

[jkgreen]

Andrew,

Text to Columns worked great. I created a macro to convert all four columns.

Thank you.