Ask Experts Questions for FREE Help !
Ask
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #1

    Apr 21, 2010, 08:49 AM
    Word & Excel Mail Merge
    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    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's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #3

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    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
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #5

    Apr 21, 2010, 02:55 PM
    Thanks for your support. Great answer.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Mail merge [ 1 Answers ]

How do you obtain mail merge?

Excel - Merge Cells [ 3 Answers ]

Any way to merge a number of cells into one cell, for example the title of many columns in a table?

MS Word & Excel Requesting Virus Scan [ 2 Answers ]

When opening a Word Excel document the message 'requesting virus scan' appears when opening the application then when opening the file the same message again. Instead of a couple of seconds for whole procedure it now takes 11 to 23 seconds. I had made no changes to my computer. Following another...

Excel & Word compatibility [ 1 Answers ]

I currently have Office 97. If documents (Word or Excel)are created in later versions of Office, will I be able to open them in Office 97?

View more questions Search