HI,
This is more like a word forum issue? Anyways, here is the solution. You need to do it in word than in excel. After you start mail merge and before you update all the fields (merged fields), you need to get the individual field codes in the document. Once you get the field codes in the mail merge document, select the amount field, right-click-Edit Field-Field Codes, use the field code as MERGEFIELD Amount \# #,##0.00. Having done this, update all the labels. And this formatting will be applied to all the labels. Let me know if you get this. Regards Ajit. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of NOURREDINE BELHAJ Sent: Thursday, June 25, 2009 6:49 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Mail Merge Word Excel 2003 Hi All, Hope you are all fine. I have an issue with the Word Function Mail Merge. I have an xls with columns Adress Cust Name Invoice Amount Date. When I m doing the Mail Merge the Number Format is as below ; 6027642.7199999997 I want to change it to 6,027,642.72 Can you please help with this Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
