Gary & Connie Burton wrote:
I have addresses included on a spreadsheet I use. When using labels everything
is fine unless I have the zip plus 4 and then the zip code will not even show
in the data source view. Thanks for any help. Connie
The problem is that the zip + 5 is interpreted as text. I fixed the
problem by creating another column with an if statement in it to convert
the numbers to text. The zip code was in column G on my spreadsheet so
I created this if statement: =IF(G29;TEXT(G29;"00000");G29).
G. K.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
