 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2008Formatting of merge fields
I am having problems formatting the dates in merge fields. The field I have is: {MERGEFIELD "Start_Date"\@"dd/MM/yyyy"} And yet on all dates where the dd is under 12, if formats it to mm/dd/yyyy - can anyone offer any advice? If you are using Word 2002, this is a known problem (see http://support.microsoft.com/kb/327579/en-us). It should have been corrected in Office XP Service Pack 3. Otherwise, which version of Word and what is the data source?  SignaturePeter Jamieson http://tips.pjmsn.me.uk >I am having problems formatting the dates in merge fields. > [quoted text clipped - 5 lines] > mm/dd/yyyy - > can anyone offer any advice? Word 2003 SP2. Data source is an Excel 2003 spreadsheet - I've tried formatting the column in Excel to text and dd/mm/yyyy but neither seem to help. Ta, cdb > If you are using Word 2002, this is a known problem (see > http://support.microsoft.com/kb/327579/en-us). It should have been corrected [quoted text clipped - 10 lines] > > mm/dd/yyyy - > > can anyone offer any advice? The simplest fix is likely to be to switch the way Word connects to Excel to DDE (check Word Tools|Options|General|Confirm conversions at open, go through the data source selection, select the DDE option in the extra dialog. But then you only get to use the first sheet in the workbook, and non-ANSI Unicode characters don't get through). SignaturePeter Jamieson http://tips.pjmsn.me.uk > Word 2003 SP2. > [quoted text clipped - 20 lines] >> > mm/dd/yyyy - >> > can anyone offer any advice? That works a treat. Thanks a lot for the help. > The simplest fix is likely to be to switch the way Word connects to Excel to > DDE (check Word Tools|Options|General|Confirm conversions at open, go [quoted text clipped - 26 lines] > >> > mm/dd/yyyy - > >> > can anyone offer any advice? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.