Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-17-2014, 08:47 AM
hwg hwg is offline Default date, time format when importing CSV files Windows 7 64bit Default date, time format when importing CSV files Office 2010 64bit
Novice
Default date, time format when importing CSV files
 
Join Date: Feb 2014
Posts: 8
hwg is on a distinguished road
Default

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.
Attached Images
File Type: png sample.png (19.9 KB, 15 views)
Attached Files
File Type: txt sample.txt (849 Bytes, 10 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Default date, time format when importing CSV files 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 date, time format when importing CSV files 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:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft