Assuming the zip codes are in column E, place the following code in column F:
Drag the formula down the column.
If you want to know why this works, click here.
If you want to know why this problem exists, click here.
Related books picked - and if possible read - by me. Sponsored by Amazon Associates.