Can you just append the 0 back on in Excel? Do something like
= Left("0000" & A1,5)
and use the Len function and if needed the If function to test for the zip4's..

Eric

__________________