Are you *sure* you're setting the field to YMD.....(Year Month Day)?

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

Regards,

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


"GKW in GA" wrote in message
...
no, I just end up with 20071225, same as the source cell

"Ron Coderre" wrote:

Try this:

Select your column of "dates"

From the Excel Main Menu:
<data<text-to-columns
Click [Next]
Click [Next]
Check: Date.....YMD
Click [Finish]

Does that help?
--------------------------

Regards,

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

"GKW in GA" wrote in message
...
I have a cell, F5, that has 20071225 in it. I want to convert this to a
date
field that displays as 12/25/2007

When I use the function =DATEVALUE(F5) , I get #VALUE!

Can you tell me how to do this without using substringing and
concantenating