Quote:
Originally Posted by hwg
How can I get Excel to use MM/DD/YY hh:mm:ss as the default date/time format when importing CSV files?
|
AFAIK, not by opening them as CSV files. You might be able to do so by importing them as text files, but that would be a lot more work than reformatting a single column. In the long run, you might do better to use a macro to both open the files & reformat the columns in one go.