I have a problem with how excel treats dates that are imported as a csv
file.

For some reason, excel occasionally transposes dates from dd/mm format to
mm/dd format.

I know that the problem isn't with the format of the cells but I think it is
the way that the exporting program recognises dates.

It may be that the problem is due to the fact that week numbers less than 12
could be interpreted as a month or a week. ( the problem does not occur on
dates that fall in week 13 or greater).

Does any one know of an easy way of solving the problem or converting the
dates ?


any help greatly appreciated


Pete