With your input in A1, use the formula:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID (A1,9,2),MID(A1,11,2),MID(A1,13,2))
--
David Biddulph

wrote in message
ups.com...
Hello

I have the following string that I need to convert into Date & time.

20061011104657

How can I do this? Thanks