hi
if the dates all have the same number of characters, you might be able to
use this in a helper column added next to the data.

=MID(A2,5,2)&"/"&RIGHT(A2,2)&"/"&LEFT(A2,4)

the above assume data is in the A column. adjust if needed.
you can copy the formula and paste special values to turn them into dates
delete the as400 dates if needed.

regards
FSt1

"Judy CS" wrote:

We have data downloaded to Excel from our AS400 server.
However the date format is YYYYMMDD without slashes to separate.
Therefore, Excel does not recognize this as a date format and is unable to
perform calculations properly.
I'm looking for a formula or process that will make this recognized as a
date format in Excel so dates can be compared.
We are currently using Microsoft Office Excel 2003.