Mail Merge: cannot display the field in Excel correctly

D

derricklo1980

Hi all, I use Word to do mail merge from an Excel source (both files a
attached), I have no idea why some fields cannot display the correc
values (0 is displayed in Word for some merge fields (USD$xx (Order))
Anything wrong in the Excel file?? Many thanks!

+-------------------------------------------------------------------
|Filename: mail merge.zip
|Download: http://www.wordbanter.com/attachment.php?attachmentid=144
+-------------------------------------------------------------------
 
D

derricklo1980

derricklo1980;493080 said:
Hi all, I use Word to do mail merge from an Excel source (both files a
attached), I have no idea why some fields cannot display the correc
values (0 is displayed in Word for some merge fields (USD$xx (Order))
Anything wrong in the Excel file?? Many thanks!!
Click to expand...

After changing the formatting to number in the Excel cells, the mai
merge in Word is working fine. Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Top