Mail merge from excel to a word document for grade reporting

[Elizabeth052]

I am importing student grades from an excel spread sheet. The averages are computed using a Sum function.  The cell is formatted with 0 decimal places and shows as a whole number in excel.  When the data is mail merged to a word document, it shows 15 decimal places.   How do I get rid of the 15 decimal places and just have a whole number showing?

[#2 · Accepted solution]

@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.

[#3]

@Hans Vogelaar 

You are amazing!    That worked perfectly!

Thank you so much!