Time
You can only make it TEXT to appear to be 29/02/2006.
=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)
If turned into a DATE it becomes 3/1/3006 as there is no Feb 29th in
2006.....
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Vaya con Dios,
Chuck, CABGx3
"DD" wrote in message
...
I have a field in a delimited CSV. file 20060229 and want to convert it to
a
date field reading 29/02/2006. How can I do that?
|