How to auto convert text to date format

D

daniel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top