Zip code

jmd
New member
Posts: 2
Joined: December 19th, 2010, 12:39 pm

Postby jmd » December 19th, 2010, 12:45 pm

I am using Apple's Number application to merge address in to L&A. A problem shows up in the zip/mail code. Here's an example: 2.0001E+4. The actual zip code is 20001. Any suggestions on how to correct this?
Nick
Member
Posts: 7237
Joined: July 6th, 2006, 3:13 am
Location: Odessa, Ukraine
Contact:

Postby Nick » December 20th, 2010, 4:03 am

Hi,

It looks like an incorrect formatting was applied to the ZIP code. Open your Numbers spreadsheet, and select the column containing ZIP codes. Then in the Cells tab of the Inspector, choose "Text" in the Cell Format pop-up menu.

Nick
jmd
New member
Posts: 2
Joined: December 19th, 2010, 12:39 pm

Postby jmd » December 20th, 2010, 5:05 pm

Thanks, Nick, that worked.

Return to “Labels & Addresses / Mail Factory”

Who is online

Users browsing this forum: No registered users and 2 guests