OK....Let's troubleshoot.

In a new worksheet, enter 20071225 in a column of cells.
Then try the method I posted.
Does that work?

If yes....
Go to your "real" data and replace one of the values by
entering 20071225 in one of the cells
Try the method again....
Does only THAT cell become a date?

If yes...something's going on with your data...
If no....Then I'm puzzled.

Let us know what you discover.
--------------------------

Regards,

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



"GKW in GA" wrote in message
...
yes, I select the field that has the 20071225 and then select data/text to
columns and follow the instructions you listed, choosing DATe..YMD

"Ron Coderre" wrote:

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