During import specify the field as a TEXT field...

but then you won't be able to use the values as dates unless you convert
them back to dates...

"Nigel" wrote:

Hi, I have a CSV file with a date/time column.

A typical value is: "2009-03-01 00:00:00.000"

When I open the CSV with Excel, the cell shows "00:00.0".

How can I show the exact value in the cell without formatting the cell to
date/time format? I have tried putting the value (in the CSV file) in between
a pair of double quotes before opening it in Excel but it doesn't work.

Regards,
Nigel