Working with 5-digit and 9-digit zip codes

I have an Excel file (using Excel 2007) which has a column devoted to zip codes. I have it formatted as "Custom" - "Zip Code" (not Zip + 4). The entries in the file are generated from imported information from an external file. The file comes in as a CSV file. I convert it to an Excel file. Here's the problem....some of the zip codes have the 9-digit format while some of the zip codes have the 5-digit format. I would like to make all the zip codes in the column "5-digit" which means I need to drop the "dashes" and the last four digits from all the 9-digit zips. I've tried everything I know, but nothing seems to work. Last night, I went down a column of 500+ zips and manually corrected them. This just doesn't work. Can anyone help me out here? Thanks very much, WDP

Can definitely fix that, actually pretty easily, once you fix your thread title I'll gladly give you a hand.

Or did you already change it...

mew?

See attached.

I think that's what you needed done?