Convert test to date
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
|