Your format says day month year thus a number above 12 will screw things up.
I think you have your days and months mixed up format wise.

"AL123" wrote:

I'm using Excel 2007 and when I convert a CSV file using "Text to Column"
menu command when the day is greater than 12 it does not convert the date
correctly. As can be seen in my example below hours 10:00 PM and 11:00 PM are
handled correctly for January 12 but hours 00:00, 01:00, and 02:00 for
January 13 are not. The "Text to Column" menu command works OK on this CSV
file in Excel 2003.

Any help is appreciated.

Format:
dd/mmm/yyyy h:mm AM/PM

CSV Text to Column
------------------------------- ---------------------------------------------

Date_Time,Value Date_Time Value
01/12/2003 22:00:00,689.2, 01/Dec/2003 10:00 PM 689.2
01/12/2003 23:00:00,626.4, 01/Dec/2003 11:00 PM 626.4
01/13/2003 00:00:00,558.8, 01/13/2003 00:00:00 558.8
01/13/2003 01:00:00,530.8, 01/13/2003 01:00:00 530.8
01/13/2003 02:00:00,512.8, 01/13/2003 02:00:00 512.8