Hi

I receive a data feed in the format of a workbook and the data that is
supplied has different data sources and as a result the time and date field
are in different formats:

29/09/2005 07:23 AM
29/09/2005 07:23 AM
29/09/2005 07:23 AM
09-05-2005
09-05-2005
09-05-2005
09-05-2005

It would appear that the top three may be associated with text and the
bottom with numeric.

I have tried the obvious ie format special DD/MM/YYYY but to no avail.

Please could you help with a quick step by step answer to resolve this issue.