![]() |
|
#3
|
||||
|
||||
|
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. |
| 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 |
Field Date: UCase()?
|
tinfanide | Word VBA | 5 | 02-08-2013 03:01 PM |
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 |