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