 |
 | 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 / April 2005Excel date format merging to Word XP version
We have recently swapped over to Windows XP and I am now having a problem with merging to Word. I need to insert a pre-determined date which is entered in excel as a dd/mm/yy (ie 03/03/05) raw data set to dddd, dd mmm yyyy (ie Thursday, 03 March 2005) format in Excel to keep this format in Word. In our old version this would merge over automatically keeping the day month etc typed out but now with XP this formatting is being lost (showing as ie 03/03/05 12:00AM). The formatting refers to the actual text rather than just the font style. Also numbers are having .0 added to the end after the merge. (ie 75 in excel (cell format etc set to numbers with 0 decimal) is being merged to Word as 75.0) Any suggestions??? See http://www.gmayor.com/formatting_word_fields.htm and/or the Excel data section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > We have recently swapped over to Windows XP and I am now having a > problem with merging to Word. I need to insert a pre-determined date [quoted text clipped - 9 lines] > merged to Word as 75.0) > Any suggestions??? These are very helpful in nutting out a few other nightmares with XP (fun fun fun) but I am unable to find anything on getting the date to come up in the right format in Word after the merge or why the .0 is appearing. Very AAggghhhhhhh > See http://www.gmayor.com/formatting_word_fields.htm and/or the Excel data > section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm [quoted text clipped - 12 lines] > > merged to Word as 75.0) > > Any suggestions??? {Mergefield datefieldname \@ "dddd, d MMM yyyy"} The decimal could be a tad more complicated { IF { Mergefield numberfieldname } = {=INT({ Mergefield numberfieldname }) } "{ Mergefield numberfieldname \# "#" }" " { Mergefield numberfieldname \# "#.##" }" } Change the fieldnames as approipriate Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > These are very helpful in nutting out a few other nightmares with XP > (fun fun fun) but I am unable to find anything on getting the date to [quoted text clipped - 28 lines] >>> merged to Word as 75.0) >>> Any suggestions??? Hello, Did you get anywhere with the .0 problem? I have tried Graham's script but no joy. The strange thing is that it merges fine on other PCs, but not this one. jonh > These are very helpful in nutting out a few other nightmares with XP (fun fun > fun) but I am unable to find anything on getting the date to come up in the [quoted text clipped - 17 lines] > > > merged to Word as 75.0) > > > Any suggestions??? What result do you get when you use the conditional field? It works here as shown. I take it you inserted the fields manually with CTRL+F9 and that you have the round brackets quotes and spaces as shown. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello, > [quoted text clipped - 35 lines] >>>> being merged to Word as 75.0) >>>> Any suggestions??? Thank you so much for all you help - The date one is now working wonders. Still troubled over the decimal point though. I copied the formula to ensure right setting then ctrl+F9 and posted into the doc and changed the numberfieldname to be the column it corresponds with - but it is merging as mergefield. I am obviously doing something wrong. Thanks again L > What result do you get when you use the conditional field? > It works here as shown. [quoted text clipped - 40 lines] > >>>> being merged to Word as 75.0) > >>>> Any suggestions??? If the mergefield construction appears in the merge result then it appears that you have not inserted all the field delimiters with CTRL+F9. You cannot copy and paste fields from listings and expect them to work. What *exactly* have you inserted? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you so much for all you help - The date one is now working > wonders. Still troubled over the decimal point though. I copied the [quoted text clipped - 56 lines] >>>>>> being merged to Word as 75.0) >>>>>> Any suggestions??? I did ctrl+F9 and then typed in IF { Mergefield PCODE } = {=INT({ Mergefield PCODE }) } "{ Mergefield PCODE \# "#" }" " { Mergefield PCODE \# "#.##" }" leaving a space between the automatically inserted { } from the Ctrl+F9 and the typing Sorry I sound so stupid Thanks again > If the mergefield construction appears in the merge result then it appears > that you have not inserted all the field delimiters with CTRL+F9. You cannot [quoted text clipped - 61 lines] > >>>>>> being merged to Word as 75.0) > >>>>>> Any suggestions??? You need to type CTRL+F9 for *each* pair of curly brackets {} What you have here is a collection of fields. Thus CTRL+F9 then in between the brackets type IF then CTRL+F9 and in between the second set type mergefield pcode etc. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I did ctrl+F9 and then typed in IF { Mergefield PCODE } = {=INT({ > Mergefield PCODE }) } "{ Mergefield PCODE \# "#" }" " { Mergefield [quoted text clipped - 77 lines] >>>>>>>> decimal) is being merged to Word as 75.0) >>>>>>>> Any suggestions??? Thank you so much - you are truely a brilliant gem L :o) > You need to type CTRL+F9 for *each* pair of curly brackets {} What you have > here is a collection of fields. [quoted text clipped - 82 lines] > >>>>>>>> decimal) is being merged to Word as 75.0) > >>>>>>>> Any suggestions??? Blush :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you so much - you are truely a brilliant gem > L :o) [quoted text clipped - 94 lines] >>>>>>>>>> decimal) is being merged to Word as 75.0) >>>>>>>>>> Any suggestions???
|
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.