Default date/time format when importing CSV files

		Microsoft Office Forums > Microsoft Excel > Excel
Default date/time format when importing CSV files

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-11-2015, 11:16 PM

macropod

Windows 7 64bit Default date/time format when importing CSV files

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

csv, import, time

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default date format	gebobs	Excel	0	03-03-2015 10:16 AM
Default date, time format when importing CSV files	hwg	Excel	3	11-17-2014 08:47 AM
Parse date and time from one cell and paste it to another for all files in a folder?	chrisd2000	Excel Programming	3	07-03-2014 10:56 AM
How to format cell in order to display both time and date	SamyCode	Excel	3	01-22-2013 03:30 PM
default font for date and time insert	kennystringer	Word	2	12-21-2011 12:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.