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

Limiting the calculations in Mailmerge
How to calculate 90 days from date in excel - Guide
How to calculate position in excel ✓ - Excel Forum
Formulas for 1st and 2nd position in class - Office Software Forum
You have hit the limit for sms codes. try again in 24 hours. - Yahoo Mail Forum
You have requested too many sms codes. You must wait 24 hours to receive another ✓ - Facebook Forum

1 response

Answer 1 / 1

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

Similar discussions

you have requested too many SMS codes. you must wait 24 hours to receive another

How to calculate positions (1st,2nd,3rd...) in Excel

Facebook

How to calculate position (1st,2nd,3rd) in excel....?

Confirm account Facebook

Similar discussions

Subscribe To Our Newsletter!