You need to use the Text Import Wizard. If the file extension is TXT then
use the menu Data - Import External Data - Import Data, otherwise, you can
use File Open. The 3rd step of the wizard allows you to select the data
type. Select text.



"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