Limiting the calculations in Mailmerge

Solved/Closed
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Jul 1, 2010 at 02:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 1, 2010 at 04:48 AM
Hello,

I prepare some letters using excell and mailmerge. when mailmerge fetch calculations from excell, the calculatios appear on letter up to 13 decimels. and calculation looks like.
10.798623100000 instead of 10.80.
pls help me to restrict the calculations to 2 decimels.

Thanks...seekermay


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 1, 2010 at 04:48 AM
* Click on the merged field on the document
* Right click and click on toggle the field code
* Then after the field name, add the formatting in this format \#"0.00" or whatever format you want
0