Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ZIP Code insanity - , How to€¦vlookup, formats, number of digits.
What is the deal with Excel and ZIP codes, I know a lot of people out there
are using Excel for address lists as I do. Whenever I have a straightforward ZIP lookup or match it turns into this big project figuring out what format the ZIP from one file is and making the other file look like it. One is text the other a number, one is missing the leading zero one looks like it has the zero but is formatted that way, I go nuts. If you been there you know. Can anyone tell me, €˜this is it, do it like this, it works every time. ? Do I need a macro, combination of funtions, what am I missing? Thanks you guys. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
Header Insanity | Excel Discussion (Misc queries) | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Custom Number Formats in Code | Excel Programming | |||
change ten digits in a cell to include phone # formats | Excel Discussion (Misc queries) |