Displaying zero as 1st digit in zipcode

J

jflo

I'm generating address labels (in Word) from mailing list that's entere
into Excel. The zip code is 07040, but it shows up in labels as "7040"
I followed the directions & clicked "zip code" in the "format cell
dialog box to format that column. I also tried entering it as text
zip code printed out as "0" only. I hope you can help - I'm working o
deadline.

Thanks.:confused
 
D

Debra Dalgleish

After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the zip code. It will look something like:
{ MERGEFIELD "Zip" }
3. Add a switch, to format the number. For example:
{ MERGEFIELD "Zip" \# "00000" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Top