Sometimes when this (or similar number v. text that is a number) happens
to me, I type a "1" in a free cell, copy it, and paste special -
multiply the array of zip codes by the "1". This should convert all to
number. The ones starting "0----" may only show the last four digits
until you reformat the cells as zip codes.

Give it a try...


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=397204