Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove Time from DateTime | Excel Discussion (Misc queries) | |||
pop up calendar using MS DateTime Picker | Excel Worksheet Functions | |||
MS Query DateTime String | Excel Worksheet Functions | |||
datetime format issues when linking access to excel | Excel Discussion (Misc queries) | |||
autodate and datetime stamp | Excel Worksheet Functions |