|New 2003 worksheet|
A1:A4 formatted as Zip Code
(Copy/Pasted directly from the worksheet)
Entered in B1 and dragged down to B4:
(Also Copied/Pasted directly from the worksheet.)
I'll try this in 2010 when I get home, but I'll be very surprised if I get different results.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.