Assuming your days and months are always 2 characters, and the year is always
4 characters
A1: 22.08.2008 00:25:00
=DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2))

Hope this helps.
--
John C


"Duane" wrote:

I have a date and time. I need it to show up as a date and it is not. I
have it imported from another program as:

22.08.2008 00:25:00

If I change the .08. to aug, it works. I can use "replace" and it all
works. But the months will change. I think it is a format thing. My excel
is set to english US. Is that something to do with it?

Thanks for any input.