Date and format problem!

This problem has been killing me - and a BIG thanks to anyone who can help figure this out....

I have a third party application that exports dates in European format (DD/MM/YYYY) and I want to format as US (MM/DD/YYYY). To make matters worse - the format is inconsistent and sometimes appears as D/MM/YYYY.

Using format cells won't work - example: My cell contains 06/02/07 and if I use format cell to change to 'DD-MMM' the output will read as June 2 and not February 6 (the real value I want).

It would seem I need a solution that rearranges the data. Is it possible to have excel rearrange the data - perhaps by the position of the '/'? Example: swap 06/02/07 for 02/06/07. The solution would need to apply to 6/02/07 as well.

One other related problem: Some of these date cells are in a 'general format'. Even after applying a format change so that is numeric and in date form I cannot manipulate the cell format - it reads the same no matter what I do. Example: A2 = 30/01/07 and is in general format. After ANY format change it reads as 30/01/07.

Raw data is attached. Please help!!

Christopher