Importing dates from text file

[lo032398]

I have counter data from a windows 2000 servers which I am trying t
graph. The text file has data in the format below.

"(PDH-CSV 4.0) (GMT Dayligh
Time)(-60)","\\SERVER1\Memory\Pages/sec","\\SERVER1\PhysicalDisk(_Total)\Avg
Disk Queue Length","\\SERVER1\Processor(_Total)\% Processor Time"
"03/31/200
23:59:41.115","0","0.0012533333333333333","0.52083333333333703"
"03/31/200
23:59:56.115","0","0.0020799999999999998","1.041666666666663"
"04/01/2004 00:00:11.115","0","0.00166","1.4062499999999978"
"04/01/200
00:00:26.115","0","0.00089333333333333333","0.88541666666667185"

Data for 03/31/2004 and all dates before that works fine but the dat
for 04/01/2004 defaults to hours and minutes. (See attached) Ha
anyone got any ideas re what is wrong.

Thanks

To

Attachment filename: date-funny.png
Download attachment: http://www.excelforum.com/attachment.php?postid=49775

 

[lo032398]

Answered this myself. On import declared column 1 as a text column.
was already processing this as a text string to get rid of th
fractions of a second