Remember, please do not double post. You had responses on your other post.
--
John C


"Duane" wrote:

I have a date imported from another program. It shows up as 22.08.2008 for
Aug 22, 2008. It is not recognised as a date in excel. Can I convert it? I
have used the "replace" function and it works well. But I would like it to
be more automatic as the months change depending on when the data is
imported. There are also several of them (1400+).

How can I change 22.08.2008 to 22/08/2008? My computer is set to
English(US). Not sure if that is it?