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

Look familiar?

"Lee" wrote:

I have imported data from an accounting program and the date format is
20070101 for January 1, 2007. I have looked at various sites that would use
Left(),Mid(),Right() to break the numbers and then put them back into
2007/01/01 but was wondering if anyone had a simpler solution.
Thanks,
Lee Coleman