Please clarify... Do you want to physically change the original values from 9 digit zip codes to 5 digit zip codes within the cells containing them? Or do you want display them "format" the cell to simply hide the last 4 digits if they are there (will require VBA code to do)? Or did you simply want to display the 5-digit zip codes in another column (with the intent of maybe hiding the original column)?
Assuming the 9-digit zip codes have the standard dash between the first 5 digits and the last 4 digits, do the following. Select the column with your zip codes, press CTRL+H to bring up the Replace dialog box, put -* (that is a dash followed by an asterisk) in the "Find what" field, leave the "Replace with" field empty, click the "Options>>" button and make sure the "Match entire cell contents" checkbox does not have a check mark in it, then click the "Replace All" button.
I need to know if your Zip Codes are numbers or text. Select anyone of your zip codes and right-click it, select "Format Cells..." from the popup menu and tell me which Category is selected on the Number tab.
