MERGE PRINTING (WORD /W EXCEL)

[PETER HO]

DEAR ALL,
i HAVE A WORD DOCUMENT NEED TO HAVE MERGE PRINTING WITH A
EXCEL FILE.
IN THE EXCEL FILE, THE DATA OUTPUT TO WORD IS A RESULT OF
FORMULA CALCULATION, LIKE 13.333336, FEW HUNDRED NUMBERS
NEED TO OUTPUT TO WORD.
i FOUND A PROBLEM IS THAT ALTHOUGH I CHANGE TO FORMAT OF
THE NUMBER INTO INTEGER, THE NUMBER SHOW IN THE WORD
MERGER PRINGTIN IS NOT INTGRE, STILL LIKE 13.33333336,
HOW CAN I SOLVE IT?
THANK YOU VERY MUCH.

 

[Beth Melton]

Hi Peter,

It would help to know the version of Word and Excel you are using. If
using Word 2002/2003 and Excel 2002/2003 then in Word do the
following:

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your datasource again for mail merge'
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead of
displaying the data as it is stored.

btw, typing in all uppercase is considered yelling in the newsgroups
and it's difficult to read.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Peter Atherton]

Peter

In the Word document right-click the calculated field and
change the format then save the document and try the merge
again.

Alternatively, alter the formula in Excel using the Round
function to say, two decimal places.

e.g =ROUND(F6*G6,2) will round the sum toresultinsay, 13.33

Regards
Peter

(e-mail address removed)