About Us

derricklo1980

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

derricklo1980

Quote:

Originally Posted by derricklo1980

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

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

Thread Tools
Show Printable Version
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge with Excel - Date not Formatting Correctly	[email protected][_2_]	Microsoft Word Help	3	August 6th 15 07:02 PM
Mail Merge field not displayed correctly	Mark	Mailmerge	1	June 14th 09 04:34 AM
mail merge - text wont display correctly	rascl	Mailmerge	8	August 18th 06 07:00 PM
mail merge using Word and Excel doesn't work correctly	enolalum	Mailmerge	2	October 29th 05 08:27 PM
Access currency field wont format correctly in word mail merge	Marnee	Mailmerge	3	June 2nd 05 05:40 AM

Menu

About Us