Here's a formula version of Nick Rothstein's VBA solution:

A1: 20070407
B1: =--TEXT(A1,"0000-00-00")
(format B1 as a date)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Here's one option....

Select your column of "dates"

From the Excel main menu:
<data<text-to-columns
Click the [Next] button twice
Check: Date.......Select YMD
Click the [Finish] button

or...if you prefer a formula...
A1: 20070407
B1: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"tenngirl" wrote:

I need to convert a date from 20070407 (yyyymmdd)

to 04/07/2007 can someone help me with this confersion.

Thanks,

Linda