dashed zip from data base to labels 51525-4107 becomes 0

[Laura]

When trying to print address labels in Publisher using my data base in Excel
the addresses with the longer zip code like 51525-4107 print out 0 for the
zip. The addresses with just five numbers 51525 print out fine.

 

[Mary Sauer]

Setup the field as text.

 

[Laura]

How do you set up the field to be text?

 

[Laura]

How do you set up the field to be text?

 

[Mary Sauer]

Select the field, format, cells, scroll down to text.