Hi Sheeloo and Joel,

Thanks for the advice.

But there's no importing and exporting involved. The CSV file will stay in
CSV format, and I'm using Excel to open the CSV file that's all.

I'm looking at how I can manipulate the data in the CSV file so that upon
opening the file using Excel, the value will be shown as it is without
becoming "00:00.0".

"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