Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/comm...el.programming |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to delete Number/Custom format codes (2007) | Excel Discussion (Misc queries) | |||
How do I shade a cell using custom number format codes. | Excel Discussion (Misc queries) | |||
Custom number format codes for negative numbers | Excel Discussion (Misc queries) | |||
Color Codes: Localizing a number format string | Excel Programming | |||
I am not able to format cells for zip codes | Excel Worksheet Functions |