SOLVED

Mail merge from excel to a word document for grade reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-1988937%22%20slang%3D%22en-US%22%3EMail%20merge%20from%20excel%20to%20a%20word%20document%20for%20grade%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1988937%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20importing%20student%20grades%20from%20an%20excel%20spread%20sheet.%20The%20averages%20are%20computed%20using%20a%20Sum%20function.%26nbsp%3B%20The%20cell%20is%20formatted%20with%200%20decimal%20places%20and%20shows%20as%20a%20whole%20number%20in%20excel.%26nbsp%3B%20When%20the%20data%20is%20mail%20merged%20to%20a%20word%20document%2C%20it%20shows%26nbsp%3B15%20decimal%20places.%26nbsp%3B%20%26nbsp%3BHow%20do%20I%20get%20rid%20of%20the%2015%20decimal%20places%20and%20just%20have%20a%20whole%20number%20showing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1988937%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1988966%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20merge%20from%20excel%20to%20a%20word%20document%20for%20grade%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1988966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F902448%22%20target%3D%22_blank%22%3E%40Elizabeth052%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EDo%20the%20formatting%20in%20Word.%3C%2FP%3E%0A%3CP%3ERight-click%20the%20average%20score%20merge%20field%20in%20the%20mail%20merge%20document.%3C%2FP%3E%0A%3CP%3ESelect%20'Toggle%20Field%20Codes'%20from%20the%20context%20menu.%3C%2FP%3E%0A%3CP%3EYou'll%20see%20something%20like%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%7B%20MERGEFIELD%20Average%20%7D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%7B%20MERGEFIELD%20Average%20%5C*%20MERGEFORMAT%20%7D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhere%20Average%20is%20the%20name%20of%20the%20merge%20field.%20Make%20it%20look%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%7B%20MERGEFIELD%20Average%20%5C%23%20%220%22%20%7D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20F9%20to%20hide%20the%20field%20code%20and%20to%20update%20the%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
Best Response confirmed by Elizabeth052 (New Contributor)
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.

@Hans Vogelaar 

You are amazing!    That worked perfectly!

 

Thank you so much!