Mail merge Labels Excel to Word - Need Help with format of numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jonella@cameron.edu - 09 Nov 2006 20:06 GMT

I am trying to make labels with Word 2003 using data from an Excel 2003
spreadsheet. The problem concerns one column that has four digit numbers,
some of which begin with zeroes. The zeroes are necessary. I did the merge
but when the labels appear in Word, there are no zeroes. How can I format
the column so that when I perform the merge in Word they have the leading
zeroes, and should the column be formatted in Excel or Word? Thanks.

Signature

Jon Ella Long

Reply to this Message

Peter Jamieson - 09 Nov 2006 20:54 GMT

If you know that your numbers will only ever have 4 digits, if you have

{ MERGEFIELD mynumber }

in Word, try

{ MERGEFIELD mynumber \#0000 }

instead (use Alt-F9 in Word to toggle between "field code" and "field
result" view.

You can also modify the way your data is stored in Excel, but in this case
it's probably harder than fixing it in Word.

Peter Jamieson

>I am trying to make labels with Word 2003 using data from an Excel 2003
> spreadsheet. The problem concerns one column that has four digit numbers,
[quoted text clipped - 3 lines]
> the column so that when I perform the merge in Word they have the leading
> zeroes, and should the column be formatted in Excel or Word? Thanks.

Reply to this Message