Thread: Time
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Time

Sorry, 3/1/2006 not 3/1/3006...."you know what I meant"....the formula is
ok, just mine typing is tired.......bed time here in St. Petersburg,
Florida......

Vaya con Dios,
Chuck, CABGx3




"CLR" wrote in message
...
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?