$$Excel-Macros$$ Re: Please provide help on mail merge numerical value

2009-07-22 Thread Sathish Jalendran
Hi, Right click on the merge field and do toggle fieldcodes and insert the follow after the mergefield(as shown below) \#"00" u will not get any decimal value Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Deep Sen

$$Excel-Macros$$ Re: Please provide help on mail merge numerical value

2009-07-22 Thread Upendra Singh
Hi Deep, Do as Below : 1. In the word merged document, right click the merged field for which you want to change the format. 2. Click "Toggle Field Code" 3. You will see something like { MERGEFIELD Dollar_Value} where "Dollar_Value" is the merge Field. 4. Append \# #