I expect you will be doing this again, and I would
suggest that you don't destroy the zip+4 codes
if you use text you should be able to use both
5 digit zips, and 5+4 digit zips, and International
zip codes, but if the required format for something is as you
say 5 digits. The fields should still normally be
text and not numbers because they are identifying
information.

Five digit codes is really only good for the US and
Caribbean. You might want to take a look
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

If you are doing Mail Merge you can work with text
dealing with numbers can be difficult. If you are working
with a column with a number format or General the 5 digit
zip codes would be treated as numbers and the 9 digit
codes entered with a hyphen would be accepted as text.
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"cdbinder" wrote in message ...
Figured it out - create a 3rd column, copy just the values, not the
referenced formulas. Then delete the other 2 columns. Time consuming, but
much less so than altering each offending 9-digit cell.