Dave Peterson: I did first copy a column of zip codes. The column has nine
digit numbers and five digit numbers. I pasted it into another worksheet,
selected Format, Special, zip + 4. Nothing happens until I double click one
of the cells and the format will change. The nine digit ones now display
correctly but the five digit ones will appear as 0001-2345 rather than 12345.
Is there any way around this?