Excel Format-Cells-Number for Zip Codes

[Guest]

Frequently I am asked to create mailing lists - I use Excel so that I can
export to Word for labels, and also to ACT for entry into my Database.

In Excel you can highlight a column of numbers, use Format -> Cells ->
Number to make all cells dates, currency, etc. It would be nice if someone
could add Zip Code, so that if you type in a 0 (zero) in the beginning (for
Eastern Zip Codes), you wouldn't have to type an apostrophe before typing the
number - example - North Oxford, MA's zip code is 01537, but you have to type
in '01537 (slows down my speed)

----------------
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/com...e6436af&dg=microsoft.public.excel.programming

 

[Mark Lincoln]

Set the cells to Text. Then, whatever you type into the cells is
displayed exactly as typed.

 

[Guest]

Set the cells to Text. Then, whatever you type into the cells is
displayed exactly as typed.

Thank you!!! This will help me so much!!!