This would be a perfect job for an intern. If I had one.
January 24, 2008 7:47 AM Subscribe
MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump...
posted by LiveToEat to computers & internet (9 answers total) 1 user marked this as a favorite
I'm doing a mass mailing and I exported about 9000 names from our customer list in Filemaker, and Excel deleted the zero at the beginning of the East coast zip codes. (i.e. Worcester, MA 1602 instead of 01602) There are about 500 zip codes like this and I have to believe there's a quick way to make a universal change and stick in the missing zero at the beginning of the zip codes. I already formatted the cells to recognize nunbers as text, but that still leaves me to fix each one by hand.
Any ideas on what to do? And please explain it in simple steps because I'm not as technologically inclined as some.