One way:

=TEXT(LEFT(A1,8),"00\/00\/0000")+MID(A1,10,255)


In article ,
"Jane" wrote:

Can anyone help me create a formula to convert the following date and time to:

12102004 5:00 pm ------ 12/10/2004 5:00 pm


thanks