Mail merge working erratically

K

krishca

I use a calculated field from Excel as a mail merge in Word. We hav
changed from Office 2K to office XP. From then on there is a decima
overflow. If my data in excel is 0.06, the same in word is reflecte
as 5.666666666666669 etc. Some one kindly help. I did not have thi
problem in office 2k:confused
 
D

David McRitchie

Hi krishca ,
If the column were text, you won't have the problem, but
since it is a numeric field in Excel XP you would want to ...

In the Confirm Data Source dialog box,
click the MS Excel Worksheets via DDE (*.xls), and then click OK.
which will make Word accept the value as shown ( .text in VBA terrm).

I would go along with that and try to avoid formatting anything within word
but More details in a posting by Debra Dalgleish including steps to
do the formatting in MS Word
http://google.com/[email protected]

Another way is to use the Text Worksheet Function in a helper column.
=TEXT(F5, "#.00")

My own page on mail merge for labels is
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
 
Top