Gene Kohlenberg wrote:
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).
I just format the column that contains the zip codes as text and enter a
space as the first character. Five character and nine character codes
work just fine, though it's a bit of a kludge.
--
Troll/Idiot
Don't try to impose your personal preferences on everyone else. Be
polite. Have a nice day.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
