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

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