Mail merging from Excel to Publisher or Word (office XP)

[Mike C]

I am a teacher in a Sheffield UK school teaching GCSE.
Part of the requirement this year is to mail merge into
either Publisher or Word from an Excel spreadsheet. Did
the same last year with no problem (office 2000) but with
Office XP now have strange results.
Mail merged figures (results of formula) now unexpectedly
develop either 4 decimal places when merged to Word, or
up to eight in Publisher. i.e 14.67 goes to 14.6667 or
14.66666667, This in spite of formating to two decimal
places and/or roundup.
My solution is to manually convert the numbers to text
but this can't be right. What are we doing wrong?
Help please

 

[Guest]

In Word you might try making sure that you have Confirm Conversion at Open activated
You can do this at Tools|Options|General
When you perform the merge choose the DDE option out of the list. This should preserve formatting from Excel. Otherwise, Word has to format the numbers itself, and it doesn't always give the desired results

tj

 

[Guest]

-----Original Message-----
In Word you might try making sure that you have Confirm Conversion at Open activated.
You can do this at Tools|Options|General.
When you perform the merge choose the DDE option out of

the list. This should preserve formatting from Excel.
Otherwise, Word has to format the numbers itself, and it
doesn't always give the desired results.

tj
.
Thank you so much - I have just tried it and it works

brilliantly! You have just helped about 220 students
achieve a GCSE grade. Please treat yourself to a drink -
you have really deserved it!

Mike C Sheffield