Thank you so much.... works Perfect :)

"ward376" wrote:

You may have text in column A.

Try this formula in column B:
=VALUE(LEFT(A2,FIND(" ",A2,1)))

and this one in column C:
=VALUE(MID(A2,(FIND(" ",A2,1))+1,FIND(" ",A2,1)-4))

then format column B as the date format you want and column c as the
time format you want.

Cliff Edwards