I spooled results from my oracle database and i changed the date format to

alter session set nls_date_format='DD/MM/YYYY HH24:MIS';

and spooled the results as a csv file. when i opened it, i found that some of my dates are in '12/03/2003 05:00:00' and some in '12/3/2003 5:00:00 AM'.

I'm using Excel 97 and tried everyway to fix the problem. i've tried formatting the cells to the same date format but it still comes out in different format. How do i go about solving this or is this a bug in Excel 97 ???

Many thx to those willing to help.