Joel,

I can not format the cells before I import the data. How would I know which
dates are in the wrong format. The CSV files come from a third party in the
format that they are. I am processing 90 to 180 separate data files that are
placed in a folder. My macro takes one file at a time and process the data.
I don't know which dates need converting for the same reason.

Any other suggestions?

Thanks for looking.

"Joel" wrote:

The best solution is to format the cells where you have dates before you
import the data. The problem is that some cells will change and other won't
bewcause some dates are illegal. If you can figure out which dates need to
be revversed this code will help

old_date = DateValue("3/10/08")
MyMonth = Month(old_date)
Myday = Day(old_date)
new_date = DateSerial(Year(old_date), Myday, MyMonth)

"Nils Titley" wrote:

I tried getting help with this before and did not get it resolved.

Here is the problem. I am processing data files in a .CSV format. These
files are processed in South Africa where they use the date format:
dd/mm/yyyy. When I process the file if the dates are in a General Format
there is no problem with the dates. But we have found that some of the files
have mixed format where the dates are in General Format and some are in Date
Format. The date format is the problem.

Example: 12/01/2008 South Africa is actually Jan 12, 2008

In General format, when I process the data and write the date to a
worksheet, the date is still 12/01/08 formatted to dd/mm/yy.
If the data is in Date Format, the date printed then becomes 01/12/08 or Dec
1, 2008. Because Excel thinks the date is Dec 1, 2008.

I need some one that is good with dates!

Thanks