Losing preceding 0 when merging numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gotcha - 02 Aug 2006 14:38 GMT

When I merge a document using an excel data base file, if I type a zip code
into the data base as 06741 then when I merge the document into word, it will
merge as 6741. How can I fix that.

Reply to this Message

Peter Jamieson - 02 Aug 2006 14:55 GMT

Usually the simplest way is to check Word Tools|Options|General|Confirm
conversions at open, go through the process of selecting the data source
again, and choose the DDE option in the extra dialog box after you choose
the file. NB, DDE can only "see" the sheet that was displaying when you last
closed the Excel workbook, or maybe the currently open sheet, if the
workbook is open.

Peter Jamieson

> When I merge a document using an excel data base file, if I type a zip
> code
> into the data base as 06741 then when I merge the document into word, it
> will
> merge as 6741. How can I fix that.

Reply to this Message

Graham Mayor - 02 Aug 2006 15:06 GMT

See the relevant section at http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When I merge a document using an excel data base file, if I type a
> zip code into the data base as 06741 then when I merge the document
> into word, it will merge as 6741. How can I fix that.

Reply to this Message