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

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

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.

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" <[email protected]> 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.

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