Ask Experts Questions for FREE Help !
Ask

Word & Excel Mail Merge

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

4 Answers
ScottGem's Avatar
ScottGem Posts: 58,015, Reputation: 28115
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.
Helpful
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?
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,373, Reputation: 5036
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
Helpful  (1)
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.
Helpful

Not your question? Ask your question View similar questions

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting

Undo
Redo
 
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



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 Spreadsheets questions Search