Thread: Date shows "00:00.0" rather than actual value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel Nigel is offline
external usenet poster
  
Posts: 98
Default Date shows "00:00.0" rather than actual value
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
Reply With QuoteReply With Quote