Forum Discussion
Word Mail Merge - Table Number Formats
Hello! I have a Word Document with Tables that I am trying to populate through Mail Merge. When I use an Excel spreadsheet as my data source, the tables populate correctly, but the number format is ...
Word's mail merge brings in Excel's internal representation of number values, and it has no way to carry along whatever display formatting you've assigned in Excel. To control the formatting in Word, you must insert formatting switches in Word's MERGEFIELD fields. For instructions, see http://www.gmayor.com/formatting_word_fields.htm.
