WebPress F9 on Windows. Press Fn + F9 on Mac. To format a numeric merge field, use the \# ... WebApr 26, 2010 · 1. With the mail merge main document open, press Alt + F9 to view the field codes 2. The field code will look something like { MERGEFIELD mynumber } 3. Change it to { MERGEFIELD mynumber \#"0.00" } 4. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes 14 people found this reply helpful ·

Mail merge fields not displaying properly - Dollar signs and percentages

WebThis video explains how to apply currency format to a mail merge field using a field switch. This problem occurs when Word does not carry over number formats from your source … WebNov 26, 2024 · Insert the new merge field you added to the data source (FormatBold). Type a space, followed by the equal sign (=) followed by "yes" or "Y" (in quotes), followed by another space. (Make sure you use the same "yes" or "Y" convention you used in step 2.) Turn on bold formatting (press Ctrl+B ). Insert the company merge field followed by a … service-disabled veterans life insurance plan

Mail Merges - Formatting Numbers in a Merge Field

WebMail merge allows you to link a Word document to database of records. Sometimes the fields in that database contain numbers that need to be formatted in a certain way. For … WebMay 7, 2024 · Mail Merge - Format of currency. I have a currency field in excel. Ex: 87,200. When I used this excel as data source to my mail merge in a word document, it … WebDec 12, 2015 · To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this: • select the field; • press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; • edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see … the ten commandments on stone