A bit late to this thread...but...

try this:

B1: =--TEXT(A1,"0000-00-00")

(format B1 as a date)

Is that something you can work with?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Judy CS" <Judy wrote in message
...
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.