Sorry Niek, the 20 April 2004 was a complete mess up, it should read 29
October 2004.

You are right about the csv file element. I have a downloaded vbs script to
convert a log file that is in a very poor format to a csv file that can be
opened and in Excel and far better formatted. Hence I cannot change how it
is doing things.

Will try renaming the file as txt as you suggest and see what happens.

Regards.
Bill.




"Niek Otten" wrote in message
...
Hi Bill,

It looks like the dates were already no "real" Excel dates; otherwise they
would have been converted (not really, shown actually) as UK dates.
Did you import the dates? If so, probably as a .csv file. Better do that
as a .txt file; that gives you the opportunity to tell Excel what type of
dates they are

Your example: 10/29/04 needs to be 20 April 2004 was probably not right?

--
Kind regards,

Niek Otten


Bill.