How to auto convert text to date format
 

I have two computer. One is Excel 2000 and other is Excel 2003. And these two
computers are same regional and time setting.

When I try to open a website in these two computers, I found that there has
a big problem here.

For example,
In Excel 2000, it will auto convert text like "1 Apr 2008" to my computer
default date format "m/d/yyyy = 4/1/2008".In Excel 2003, it cannot do this
automation.

Because I have many vba programs are based on the default date format
"m/d/yyyy", which make me very inconvenience.

Thank you very much!

Daniel