I have a report in an accounting program called MYOB. I chose to export the
report to Excel 2003. However, Excel shows the dates (found under one column)
in two different formats. i.e. some of the dates appear in this format
(04-April-2007), while others appear in another format which is (04/05/2006).

Also, some of the dates are flipped. For example the date originally
11-April-2007 becomes 04-Nov-2007

All these dates are under one column.

Could any one help me please?

I want these dates to be in one format (dd/mm/yy). But when I go to "Format
Cell" to pick my format, Excel does not change the formats of all the dates.
It only changes the dates that have this format (06-May-05)

I also want the dates to be correct and not flipped

This problem happens sometimes when the original dates in the MYOB report is
in US format (mm/dd/yy)

Please help me

Thanks