#1
|
|||
|
|||
Default date, time format when importing CSV files
I often use Excel to view CSV files that contain timestamps. When I open the CSV files in excel, the timstamps get formatted to MM/DD/YY hh:mm
Seconds are not displayed. They are still there. If I edit a timestamp cell I can see the full timestamp, with seconds. But if I then save this file back to CSV, the seconds are truncated, and the CSV only contains the hour and minute of the timestamp, with all seconds showing 00. I can reformat all the dates to MM/DD/YY hh:mm:ss after opening the CSV, but that's a pain to do every time. How can I get Excel to use MM/DD/YY hh:mm:ss as the default date/time format when importing CSV files? Excel gets the date format from the regional settings in Windows. Regional settings in Windows have both Long and Short date formats. From Control Panel "Region and Language" -> Formats tab: Short gate: M/d/yyyy Long date: dddd, MMMM dd, yyyy Short time: h:mm tt Long time: h:mm:ss tt How do I tell Excel to use the Long Time format instead of the Short Time, when importing CSV's? Or, better, how do I tell it to use a format I specify? Thanks, hwg |
#2
|
|||
|
|||
No responses? So there's no way to do this?
|
#3
|
|||
|
|||
Can you attach a sample csv?
|
#4
|
|||
|
|||
The forum software won't let me upload a ".csv" file, so I have attached it as a ".txt" file.
Also attached is a screenshot of the way it looks when I open it in Excel. The timestamps contain hh:mm:ss, but the seconds don't show. If I save this back out to csv, it will truncate the seconds. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
How to format cell in order to display *both* time and date | SamyCode | Excel | 3 | 01-22-2013 03:30 PM |
Outlook 2010 does not use default appointment time as shown in Options\Tasks\default | Axel | Outlook | 1 | 01-19-2012 09:39 AM |
default font for date and time insert | kennystringer | Word | 2 | 12-21-2011 12:46 PM |