 |
 | 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 2004Word/Excel Mail Merge Formatting Problems
I'm creating a format letter for our company payout of the annual bonus. On each letter, there will be a chart containing the variables that help us arrive at each indivduals percentages and payout. My problem is that the format from the excel spreadsheet is not carryover. So instead of having the following: 29.25% 117.01% $68,750 $11,618 I'm getting this: 29.253124637 117.0125687423 68750 11618 What's going on? I've gone through the mail merge wizard and it's hitting the right fields, but none of the formatting is carrying over... Thanks! Michele I've managed to figure out the $ formatting. But I still cannot get the % to work properly. The following is the fieldcode that is currently being used, however it's only displaying .10% instead of 10% (the % is hardcoded into the letter): {MERGEFIELD "F"}% I've also tried the following but with no result: {= 100 * {MERGEFIELD "F"} \ #0%} Addtionally, I need the date format in the letter to come out as follows (like it is in the spreadsheet): DD-MON-YR (i.e. 17-Feb-04 Currently it's reading as 02/17/04 Thank you again! Michele >-----Original Message----- >I'm creating a format letter for our company payout of the [quoted text clipped - 17 lines] >Michele >. Michelle, Would you tell me how you figured of the $ formatting as I am having the same problem and can't seem to get it figured out. Thanks Judy >-----Original Message----- >I've managed to figure out the $ formatting. But I still [quoted text clipped - 44 lines] >> >. Judy, I did the following" Alt + F9 ${MERGEFIELD \ #"#,##0"} HTH Michele >-----Original Message----- >Michelle, [quoted text clipped - 56 lines] >> >. I'm having a similar problem with 9-digit zip codes. They will merge from data sources formatted as 9-digit zips, but the hyphen is missing. > I'm having a similar problem with 9-digit zip codes. They will merge > from data sources formatted as 9-digit zips, but the hyphen is > missing. This is covered at http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><< Did you use ctrl-F9 to insert both sets of field braces(the {} braces) in the nested expression? FWIW I would probably lay out the expression like this: { ={ MERGEFIELD "F" }*100 \#0% } > DD-MON-YR (i.e. 17-Feb-04 > > Currently it's reading as 02/17/04 { MERGEFIELD yourdatefield \@MM-DDD-YY } -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > I've managed to figure out the $ formatting. But I still > cannot get the % to work properly. The following is the [quoted text clipped - 41 lines] > >Michele > >. Peter, Thanks for the tip on the date. Worked like a charm. Still having problem with the %, keep getting syntax error. I've entered the following: {={MERGEFIELD "F"}*100 \# 0%} as suggested... Any other suggestions or help? Thanks again! Michele >-----Original Message----- >Did you use ctrl-F9 to insert both sets of field braces(the {} braces) in [quoted text clipped - 60 lines] > >. Are you sure you have \# and not /# which would throw an error. Have you updated the field (F9) after making the changes? Have you tried bracketing eg {=({MERGEFIELD "F"}*100) \# "0%"} Did you insert the second set of {} with CTRL+F9? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Peter, > [quoted text clipped - 71 lines] >> >> . Michele, I am having a similar problem. Request being included in any responses. Thank you. >-----Original Message----- >I'm creating a format letter for our company payout of the [quoted text clipped - 17 lines] >Michele >. |
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.