I have a spreadsheet that was imported from a .csv file and some dates/times
appear in different formats:

5/28/06 12:00
5/29/06 0:00
5/29/06 12:00
5/30/06 0:00
5/30/06 12:00
5/31/06 0:00
5/31/06 12:00
1-JUN-2006 00:00
1-JUN-2006 12:00
2-JUN-2006 00:00
2-JUN-2006 12:00
3-JUN-2006 00:00
3-JUN-2006 12:00
(down through 9-JUN-2006 12:00)
6/10/06 0:00
6/10/06 12:00
6/11/06 0:00
6/11/06 12:00
....

I've tried selecting the entire column and format it using right-click,
Format Cells/ Number/Date then mm/dd/yy hh:mm and all other cells format
correctly, with the exception of the x-JUN-2006 cells. Even if I format
the entire column to just Time, all cells except the x-JUN-2006 files will
change to just the time.

I'm running Excel 2003 SP2.

Thanks in advance!