Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Field showing "0"
Hello,
I am working on a mail merge with a merge field corresponding to a Excel cell that can either contain numbers or both letters and numbers (the format of those cells in Excel is set as 'text'). But in my Word doc, only the strictly-numbers cells are showing. If there is a letter in the corresponding cell of the Excel file, it will show as 0 in the Word doc. How do I fix this? Thank you, Caroline |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Field showing "0"
See http://tips.pjmsn.me.uk/t0003.htm
- the DDE method method mentioned there may help. Otherwise, I think you'll either have to modify your data source formatting in some way or e.g. copy/paste your Excel table into a Word document and use that as the data source. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Caroline wrote: Hello, I am working on a mail merge with a merge field corresponding to a Excel cell that can either contain numbers or both letters and numbers (the format of those cells in Excel is set as 'text'). But in my Word doc, only the strictly-numbers cells are showing. If there is a letter in the corresponding cell of the Excel file, it will show as 0 in the Word doc. How do I fix this? Thank you, Caroline |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I set up a "expand/collapse" or "show/hide" field in Word | Microsoft Word Help | |||
eliminate "copy" of "saved as" document showing up in file list | Microsoft Word Help | |||
Document saved as "Final Showing Markup" opens as "Final" | Microsoft Word Help | |||
files I want to "save as" are all showing "file permission error" | Microsoft Word Help | |||
{MERGEFIELD"Title"} is now showing for Title merge field before | Mailmerge |