 |
 | 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 / August 2004Mail Merg with excel Spreadsheet
I have imported data from excel xp spreadsheet into Word xp to use in mail merg, but when completed the merg the dates from the merg are in American ( mm/dd/yy), in the spreadsheet the field for Date is set to english Uk ( dd/mm/yy) also the regional settings are set to UK English has anyone else had this problem and knows how to sort it out.... See the FAQ on "Dates: day/month reversed" at http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm (this is Word MVP Cindy Meister's website). > I have imported data from excel xp spreadsheet into Word > xp to use in mail merg, but when completed the merg the [quoted text clipped - 3 lines] > has anyone else had this problem and knows how to sort it > out.... I have tried what out what you tried.. but when i changed the format of this large spreadsheet it changed all the dates... E.g date was... 26/02/78 the text would be 28547 and this document is very large, and to amend all the dates would be more of a problem.... anything else you could suggest...
|
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.