| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Zip Code Formatting
Hi Jerry,
Zip codes should really be text instead of numbers, to convert them in place to text with a macro retaining all digits that you have, see Fix up for 5 digit US zip codes (#fixUSzip5) http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 --- HTH, David McRitchie, My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change case...help please | Excel Worksheet Functions | |||
| can you entre a bar code into a excel cell? | Excel Worksheet Functions | |||
| VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Threaded Mode
