Mail merge from excel to a word document for grade reporting

Elizabeth052

Do the formatting in Word.

Right-click the average score merge field in the mail merge document.

Select 'Toggle Field Codes' from the context menu.

You'll see something like

{ MERGEFIELD Average }

or

{ MERGEFIELD Average \* MERGEFORMAT }

where Average is the name of the merge field. Make it look like this:

{ MERGEFIELD Average \# "0" }

Press F9 to hide the field code and to update the result.