![]() ![]() ![]() Includes the specified character in the result. Merging that field - displays "-80" andĪdds a plus sign to a positive result, a minus sign to a negative result, or a space if the result is 0 (zero). Lets say you have a data file with a single field called 'Number', which contains the following records: To preserve numeric data youve formatted as a percentage or as currency during a mail merge, follow the instructions in the 'Step 2: Use Dynamic Data Exchange (DDE) for a mail merge' section. The person can either have a 100 or some variation of a percentage like so: 19.25. There are two different ways the percentages need to be formatted. If you use pdfMachine merge to convert a Word Mail Merge document the Word mail. In other words for a number greater than zero the result is formatted as $,0.00įor numbers less than zero - the number is formatted as negative - in this case "negative" will be enteredįor a result of zero - the number is formatted as zero - and again in this example will be entered as "zero" Format any numerical data like percentages or currency values in any new or existing data source in Excel that you intend to use in a Word mail merge. I'm currently working on building some reports and need help getting a percentage format to display correctly in the MS Word mail merge I am doing. Rules Formatting is specified in the pdfMachine merge profile or template. Using the Answer Box : Numbers dont merge right in Word, I figured out how to get the dollar amounts to merge correctly, but I didnt find a formate to use to get the percentages to merge correctly. The two semi colons at the end determine what happens with negative numbers and zeros. 254 Percent button ( Formatting toolbar ), 545 Percent Style button. I am trying to do a mail merge that has names, dollar amounts and percentages. Zero or negative numbers will display nothing. To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield, as follows. \#"$,0.00 "Īny positive number will display in a dollar format (the dollar sign being optional again). Add an equals sign in front of the merge field, and 100 after it this tells it to multiply the value of that field by 100, making it a percentage rather than a decimal. This can be achieved with a conditional field, or more simply with a variation on the above numeric switch e.g. You may wish to suppress the field result altogether, when the numeric content is 0 or a negative number. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |