View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kh[_2_] kh[_2_] is offline
external usenet poster
 
Posts: 3
Default Datetime CSV format

Hi. What rules does Excel employ when importing datetime values from CSV
files? From what I can work out CSV files containing datetime data in the
form "dd-MMM-yyyy HH:mm:ss" imports correctly, but I am unable to test this
on regionally configured machines so I cannot tell if this will always work.
For example, will time data always be treated as 24HR values?

I cannot find this documented anywhere.

Thanks