Mail 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 Don't waste time cleaning your date and time data so you can use it in a Mail Merge - clean it automatically with a merge field switch!The Course:This is par In this article. Format numbers as currency. Remove currency formatting. What's the difference between the Currency and Accounting formats? Create a workbook template In the Microsoft Access query, use the FORMAT() function to format the data to be merged in Microsoft Word. More Information. By default, Word uses OLEDB to connect to the data source when performing a mail merge. You can force Word to use Dynamic Data Exchange (DDE) by using programming code to access the data
Choices for formatting fields in Word Mail Merge - Office Watch
Mail Merge date showing as number in Word. I have an excel spreadsheet that I use to create my mail merge in word. My mail merge has been working fine until today. I have 3 merge fields that show dates and one of them is now only showing numbers, the other two are still formatted correctly. Nothing has changed in my Formatting currency and number properly during mail merge in Word. Please add the following formatting data \# $, into the merge file of currency, and the merge field of currency should look like this: {MERGEFIELD CURRENCY\# $,} Note:the '\# $,' in the field is referred to as a numeric picture [HOST] possibilities include
Video: Advanced mail merge - Microsoft Support
When performing a mail merge in Word, numbers don't always automatically display with the correct formatting (currency, decimals, etc.). Here's how to fix it Microsoft Office Word – Automatically Format Currency Mail Merge Fields. Monday, 19 December by Adrian Gordon Last updated: Friday, 26 2. Use a “Numeric Switch” in Word. The second way to cajole Mail Merge into displaying numbers from Excel correctly is to modify the Word document. Specifically, this means applying the desired number format code to the Merge Fields in the Word document Answer. To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this: • press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; • run your mailmerge. Note1: The '\# $,' in the field is referred to as a numeric picture switch Answer. Doug Robbins - MVP Office Apps & Services (Word) MVP. Replied on June 20, Report abuse. It appears that the $ symbol is not part of the merge field. If you remove it and then use the following field switch. { MERGEFIELD TotalSubcontract \# $, } You will not get the spaces between the $ symbol and the numbers In this video I demonstrate how to format mail merge fields with thousands separators (commas). The switch code is \#, Select a column containing integer values. Right-click the selected cells and choose Format Cells from the pop-up menu to display the Format Cells dialog box. Click on the Text selection in the Category list. Click OK to apply the format change. The data in the selected cells is now in text format