Reply to thread

Message: [QUOTE="Phillip Jones, post: 6802163"] how are you formatting the cells in which the zip codes are in you do know that both in 2004 and 2008 you highlight the entire Column you have the zip codes in the go to Format > then numbers then special and choose zip codes. Then go back to the cells that have 9 digits and command click on each of them go back and choose Zip + 4. Then you should be able to sort them and they should sort correctly. If your trying to sort each personal addresses or Business addresses you sort by Last name for people ( have spread sheet set: First name Middle Name or Initial Last Name address address2 City State Zip Phone work phone Fax Cell or Business Business Name address address2 City State Zip Phone Fax Cell Home Phone. in case of of Business you sort on Business Name, then City or Zip (if they have more than one address. -- ------------------------------------------------------------------------ Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling 616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868 Martinsville Va 24112 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet ------------------------------------------------------------------------ If it's "fixed", don't "break it"! mailto:pjones@kimbanet.com <[URL]http://www.kimbanet.com/~pjones/default.htm[/URL]> <[URL]http://www.kimbanet.com/~pjones/90th_Birthday/index.htm[/URL]> <[URL]http://www.kimbanet.com/~pjones/Fulcher/default.html[/URL]> <[URL]http://www.kimbanet.com/~pjones/Harris/default.htm[/URL]> <[URL]http://www.kimbanet.com/~pjones/Jones/default.htm[/URL]> <[URL]http://www.vpea.org[/URL]> [/QUOTE]

Verification