 |
 | 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 / February 2007Problem with date format
I have an excel sheet that contains (amongst other data) a date of birth formatted in UK style dd/mm/yyyy. On merging into word the date appears as US format (i.e. mm/dd/yyyy) I have checked that the regional settings in Windows, Word and Excel are set to UK not US. Any help gratefully apreciated. Gavin. Oh yes, I'm using Word/Excel 2002 on XP Home SP2 Now sorted... I had worked out that using the field codes I could change the date format using the switch \@"dd/MM/yyy", but it had not been working. Realised I had typed it as /@... Schoolboy error! Gavin. >I have an excel sheet that contains (amongst other data) a date of birth >formatted in UK style dd/mm/yyyy. [quoted text clipped - 9 lines] > > Oh yes, I'm using Word/Excel 2002 on XP Home SP2 Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but then after the mail merge it appears has 01/17/2006. I tried to format, I change to toogle and format as you told me, I get this filead: {Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006 Why the months apears as zeros? I even tried to change in Regional Setting the short date to dd/mm/aa but nothing. The best that I could get was making a trick. After all register in Excel, I insert another register and I put some text into the date column. Any ideas? Regards, Marco > Now sorted... > [quoted text clipped - 19 lines] > > > > Oh yes, I'm using Word/Excel 2002 on XP Home SP2 Hi. I already find out my problem. I wasn't using M in upper case. I was using mm. Marco > Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but > then after the mail merge it appears has 01/17/2006. [quoted text clipped - 39 lines] > > > > > > Oh yes, I'm using Word/Excel 2002 on XP Home SP2 |
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.