![]() |
#2
|
||||
|
||||
![]()
If you want 'Mar-13' to remain 'Mar-13', you would probably need to use either:
• Excel's Data>Get External Data>From Text function and set the comma delimiter then format the affected column as text; or • a macro to convert the date back to a string after opening in Excel. Note that you'll need to do this every time you open the csv file. The alternative is to use a macro to read the csv file into Excel one line at a time and output each affected field in text format. This would be a much slower process, though, and would still need to be done every time you open the csv file.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
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 |
![]() |
tinfanide | Word VBA | 5 | 02-08-2013 03:01 PM |
![]() |
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 |