#1
|
|||
|
|||
Mail Merge: cannot display the field in Excel correctly
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 instead in Word for some merge fields (USD$xx (Order)). Anything wrong in the Excel file?? Many thanks!!
|
#2
|
||||
|
||||
Your currency values have all been input as text. You can see this from the fact they're right-aligned and are prefixed with '. Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.
You can remedy the problem by inputting a 1 in an unused cell, copying it, then selecting the blocks of numeric text and using Paste Special > Values > Multiply.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
But may I know why some cells can be displayed in Word normally in mail merge while some (with the same format) cannot?
|
#4
|
||||
|
||||
As I said:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
Cross-posted at: http://www.techsupportforum.com/foru...ly-660954.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Thanks a lot.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
time field issue in mail merge | Aude | Mail Merge | 16 | 05-18-2014 06:22 AM |
Import field from Excel to Powerpoint | xgravity23 | Office | 8 | 11-22-2012 02:08 PM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
currency not showing correctly on mail merge | tonywatsonmail | Mail Merge | 1 | 12-07-2011 04:29 PM |
Date not transfering to mail merge correctly | tonywatsonmail | Mail Merge | 1 | 07-01-2011 05:30 AM |