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.