Mail merge working erratically

[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

 

[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

 

[Mike A]

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


---

Notice the careful avoidance of the word 'upgraded' ;~)

Check your spreadsheet cells for percentage formatting - try changing
it to number (or even general); and check your options - unselect
'Automatic percent entry' if it is checked.




Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers