Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-30-2013, 09:34 AM
BobBridges's Avatar
BobBridges BobBridges is offline Date field Windows 7 64bit Date field Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

What you have to understand, step10, is that a CSV file is a sort of extract of a single worksheet that contains just the text of each cell's value. No formulae, just the results. No formatting, which means no fonts, colors, borders or special output formats, including dates.

Therefore when you read in a CSV, Excel can see only the value, not the way you want it expressed. If you want to save a date format from one session to the next, you have to save the worksheet in one of the formats (using Save As) that isn't text only. That's most of them; the default is .xls[x], and it'll save all that stuff for you. Really CSV is intended only to help you transfer data between Excel and other applications.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Date field Field Date: UCase()? tinfanide Word VBA 5 02-08-2013 03:01 PM
Date field Date Field to add 10 Days to Current Date Erbwon Word 6 11-12-2012 06:17 PM
Please help me with creating due date field Artemio Word 1 03-01-2012 08:10 PM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:29 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