Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Fields shows "ZERO"
Hi..
I have a data in excel which i merge in word ..but where ever the data in not there in excel...it puts "ZERO" which i have to painfully remove one by one after merge...anything which suppress this menance..other issue is that.. i hav EMI ..colum which has numbers and some have " AS PER SCHEDULE" while i merge ...the numbers appears where ever it is and "ZERO" in the place of "AS PER SCHEDULE" which i want the same data as there in excel..excatly..how can I get all what is there in excel..i want simply merge..no more gimmicks..it plays very hard to change each every page..pls help..another deadly issue is where ever i have blank fields in my cheque date column which i merge it in word..I get "12:00 AM" which i dont want...what is this...i want the program to merge and leave it blank ..if there is no value..why to put unnecessary by itself.....pls help me..to sort out..this very intellegent barracks..of no use to me!!!!!!!!! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Fields shows "ZERO"
Do you mean it puts "0", or do you really mean it puts the text "ZERO" ?
If it is "0" I suggest you try the DDE method mentioned at http://tips.pjmsn.me.uk/t0003.htm (I know this is not a real solution but if you read the rest of the page there you will see why it is very hard to solve this problem properly unless Microsoft change their software). -- Peter Jamieson http://tips.pjmsn.me.uk "Safi." wrote in message ... Hi.. I have a data in excel which i merge in word ..but where ever the data in not there in excel...it puts "ZERO" which i have to painfully remove one by one after merge...anything which suppress this menance..other issue is that.. i hav EMI ..colum which has numbers and some have " AS PER SCHEDULE" while i merge ...the numbers appears where ever it is and "ZERO" in the place of "AS PER SCHEDULE" which i want the same data as there in excel..excatly..how can I get all what is there in excel..i want simply merge..no more gimmicks..it plays very hard to change each every page..pls help..another deadly issue is where ever i have blank fields in my cheque date column which i merge it in word..I get "12:00 AM" which i dont want...what is this...i want the program to merge and leave it blank ..if there is no value..why to put unnecessary by itself.....pls help me..to sort out..this very intellegent barracks..of no use to me!!!!!!!!! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Fields shows "ZERO"
Hi Safi,
Word's mailmerge does not insert 'ZERO' if a field is empty - it may interpret an numeric empty field as '0' and an empty date field as '1/1/1900 12:00AM', however. To suppress an unwanted '0', you'll need to modify the mergefield by adding a numeric picture swith to it. To do this: .. select the formfield and press Shift-F9. You should see something like '{MERGEFIELD Value}' .. add a numeric picture switch to the field (eg '{MERGEFIELD Value $#,##0.00;($#,##0.00);}. It's the final ';' that supresses zero values. Note that this will suppress both the 0s resulting from empty fields and those from fields containing 0s. To suppress the unwanted '12:00 AM', you'll need add an IF test. To do this: .. select the mergefield and make a copy of it. You should see something like «Date» «Date» .. Press Ctrl-F9, to wrap a field around these, so that you get: { «Date» «Date» } .. Fill in between the braces, paying careful attention to the spacing, so that you end up with: {IF«Date» "12:00 AM" «Date»} When you're done, run your mailmerge. -- Cheers macropod [MVP - Microsoft Word] "Safi." wrote in message ... Hi.. I have a data in excel which i merge in word ..but where ever the data in not there in excel...it puts "ZERO" which i have to painfully remove one by one after merge...anything which suppress this menance..other issue is that.. i hav EMI ..colum which has numbers and some have " AS PER SCHEDULE" while i merge ...the numbers appears where ever it is and "ZERO" in the place of "AS PER SCHEDULE" which i want the same data as there in excel..excatly..how can I get all what is there in excel..i want simply merge..no more gimmicks..it plays very hard to change each every page..pls help..another deadly issue is where ever i have blank fields in my cheque date column which i merge it in word..I get "12:00 AM" which i dont want...what is this...i want the program to merge and leave it blank ..if there is no value..why to put unnecessary by itself.....pls help me..to sort out..this very intellegent barracks..of no use to me!!!!!!!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
Mail Merge "Go to Record" shows only 2 digits | Microsoft Word Help | |||
Ruler shows "ch" instead of "in" Not Options/language problem | Microsoft Word Help | |||
Mail Merge - Fields missing within "insert merge field" tab | Mailmerge | |||
Word shows "save" and "save" in drop down menu- no "save as" | Microsoft Word Help |