Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Help with Formatting Percentages in Mail Merge Master Document
I am using Word 2003 to create letters the merge payroll data from an Excel
2003 spreadsheet. Graham Major's formatting instructions ( http://www.gmayor.com/formatting_word_fields.htm ) have helped immensly to display the currency and date fields properly. However, I can't seem to get the percentage format to work. The suggested "{ ={MERGEFIELD "Percent_Increase" } * 100\* "0%" }" renders "!Syntax Error, {" If I use: { MERGEFIELD "Percent_Increase" * 100\* "0%" } it renders "0%" for an input value of 5.00% (on the Excel spreadsheet). If I use: { MERGEFIELD "Percent_Increase" * 100\* "0.00%" } it renders "0.05%" for an input value of 5.00% (on the Excel spreadsheet). If I use: { MERGEFIELD "Percent_Increase" * 100\* "0.0%" } it renders "0.1%" for an input value of 5.00% (on the Excel spreadsheet). Note: All of the column names in the Excel spreadsheet show up in the Word master document enclosed in quotation marks (i.e., "). I've been trying many different combinations of the suggested mergefield code, but to no avail. Basically, it appears that the multiplication by 100 is not effective. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Merge Percentages from Excel to Word not working per your posting | Mailmerge | |||
merge percentages from excel to word | Mailmerge | |||
percentages change when mail merge from excel | Mailmerge | |||
Formatting of Subdocument via "INCLUDE" into a Master Document | Formatting Long Documents |