Log in

View Full Version : Word & Excel Mail Merge


Alejandro Sanchez
Apr 21, 2010, 08:49 AM
When I obtain a number from an Excel database to insert it in a Word document, how can I edit that number on Word??

ScottGem
Apr 21, 2010, 09:30 AM
Define edit? You can't change the data you are pulling from Excel unless you do the merge to another document.

Alejandro Sanchez
Apr 21, 2010, 09:49 AM
When word import the number from the excel database the number is displayed with 10 decimals and I want to edit the number to change it to just 2 decimals. How can I do that?

JBeaucaire
Apr 21, 2010, 01:50 PM
The primer on this page shows how to set the decimal value "rounding" values in your Mail Merge field switches.

Changing How Word Displays Numbers in Mail Merge (http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm)

Alejandro Sanchez
Apr 21, 2010, 02:55 PM
Thanks for your support. Great answer.