Forum Discussion
Mail merge from excel to a word document for grade reporting
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?
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.
2 Replies
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.
