+ Reply to Thread
Results 1 to 2 of 2

zip code formatting

  1. #1
    MLD
    Guest

    zip code formatting

    A user had a weird issue the other day. She received an Excel table full of
    names and addresses. Not so weird. But the person who generated it did not
    use a consistent format in the Zip Code field, so the zips beginning with
    zero, were all Smart Tagged as "this cell is formatted as text or has an
    apostrophe in it'. And they did - in a mixed manner. When my user tried to
    make mailing labels, those beginning with zero only populated the label zip
    field with a '0'. I tried everything, clearing the formats of the column,
    resetting, copying and pasting as plain text, using the Special Format -
    Zip Code setting, using Text format on all - nothing worked to get accurate
    output on the labels.

    As anyone seen this? What did I miss?

    Thanks,
    -Monica



  2. #2
    Registered User
    Join Date
    08-18-2005
    Posts
    59

    RE: zip code formatting

    Sometimes when this (or similar number v. text that is a number) happens to me, I type a "1" in a free cell, copy it, and paste special -> multiply the array of zip codes by the "1". This should convert all to number. The ones starting "0----" may only show the last four digits until you reformat the cells as zip codes.

    Give it a try...
    Excel_Geek
    http://blog.excelgeek.com/

    "...I'll do that in Excel for $50..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1