+ Reply to Thread
Results 1 to 5 of 5

format zip codes in Excel

  1. #1
    asSYSter
    Guest

    format zip codes in Excel

    When entering data in an Excel spreadsheet, any zip codes that begin with
    zero, such as mine "03301" drop the leading zero. Why can't one of the
    formatting options be a zip code format that deals with the fact that you
    need to change the format to text (which doesn't always work)?

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...lic.excel.misc

  2. #2
    Gary''s Student
    Guest

    RE: format zip codes in Excel

    There is no problem. If a cell is formatted as a ZIP code, leading zeros are
    retained.
    --
    Gary''s Student


    "asSYSter" wrote:

    > When entering data in an Excel spreadsheet, any zip codes that begin with
    > zero, such as mine "03301" drop the leading zero. Why can't one of the
    > formatting options be a zip code format that deals with the fact that you
    > need to change the format to text (which doesn't always work)?
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/comm...lic.excel.misc


  3. #3
    Dave O
    Guest

    Re: format zip codes in Excel

    You can create a custom format by right-clicking the appropriate cell,
    then select >Format Cells and select the Number tab along the top.
    Select Custom from the list on the left. In the Type: box (which shows
    the current format of the cell) type ##### or #####-#### if you want
    zip+4 . Click OK and you're done.


  4. #4
    Myrna Larson
    Guest

    Re: format zip codes in Excel

    Hmmm... In Excel 2003, under Format/Cells/Number/Special, I see Zip code and
    Zip+4. Seems to me they have been there for several versions now <g>.

    On 3 Oct 2005 07:08:00 -0700, "Dave O" <CycleZen@yahoo.com> wrote:

    >You can create a custom format by right-clicking the appropriate cell,
    >then select >Format Cells and select the Number tab along the top.
    >Select Custom from the list on the left. In the Type: box (which shows
    >the current format of the cell) type ##### or #####-#### if you want
    >zip+4 . Click OK and you're done.


  5. #5
    Danno
    Guest

    RE: format zip codes in Excel

    I simply add an apostrophe before the zero.

    "asSYSter" wrote:

    > When entering data in an Excel spreadsheet, any zip codes that begin with
    > zero, such as mine "03301" drop the leading zero. Why can't one of the
    > formatting options be a zip code format that deals with the fact that you
    > need to change the format to text (which doesn't always work)?
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/comm...lic.excel.misc


+ 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