Home

Word Mail Merge - Table Number Formats

%3CLINGO-SUB%20id%3D%22lingo-sub-302885%22%20slang%3D%22en-US%22%3EWord%20Mail%20Merge%20-%20Table%20Number%20Formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302885%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20have%20a%20Word%20Document%20with%20Tables%20that%20I%20am%20trying%20to%20populate%20through%20Mail%20Merge.%26nbsp%3B%20When%20I%20use%20an%20Excel%20spreadsheet%20as%20my%20data%20source%2C%20the%20tables%20populate%20correctly%2C%20but%20the%20number%20format%20is%20incorrect%20(see%20attached%20example%20of%20the%20merged%20document).%26nbsp%3B%20Where%20the%20number%20I%20want%20may%20be%206.0%2C%20the%20merged%20document%20is%20displaying%206.00000000.%26nbsp%3B%20I%20can%20not%20find%20a%20way%20to%20change%20the%20format%20in%20the%20table%20cells.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20your%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-305941%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20Mail%20Merge%20-%20Table%20Number%20Formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-305941%22%20slang%3D%22en-US%22%3E%3CP%3EWord's%20mail%20merge%20brings%20in%20Excel's%20internal%20representation%20of%20number%20values%2C%20and%20it%20has%20no%20way%20to%20carry%20along%20whatever%20display%20formatting%20you've%20assigned%20in%20Excel.%20To%20control%20the%20formatting%20in%20Word%2C%20you%20must%20insert%20formatting%20switches%20in%20Word's%20MERGEFIELD%20fields.%20For%20instructions%2C%20see%20%3CA%20href%3D%22http%3A%2F%2Fwww.gmayor.com%2Fformatting_word_fields.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.gmayor.com%2Fformatting_word_fields.htm%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303840%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20Mail%20Merge%20-%20Table%20Number%20Formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303840%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F187164%22%20target%3D%22_blank%22%3E%40Gaye%20Dougherty%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20changing%20the%20decimal%20points%20in%20the%20source%20Excel%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20not%20be%20able%20to%20change%20the%20way%20it%20looks%20in%20Word%20as%20it's%20drawing%20the%20data%20from%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20if%20you%20can%20get%20the%20Excel%20source%20to%20drop%20to%201%20decimal%20place%20and%20then%20do%20the%20mail%20merge%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20how%20you%20go%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Gaye Dougherty
Occasional Contributor

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 incorrect (see attached example of the merged document).  Where the number I want may be 6.0, the merged document is displaying 6.00000000.  I can not find a way to change the format in the table cells.  

Thanks so much for your assistance.

2 Replies

Hi @Gaye Dougherty

 

Have you tried changing the decimal points in the source Excel document?

 

You will not be able to change the way it looks in Word as it's drawing the data from Excel.

 

See if you can get the Excel source to drop to 1 decimal place and then do the mail merge again.

 

Please let me know how you go?

 

Cheers

Damien

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.

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Using Flow to send out automatic emails on a weekly basis
sokva in Office 365 on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Outlook, PowerPoint, Excel, Word Version 1.0?!
boossy in Discussions on
3 Replies