Quote Originally Posted by MarvinP View Post
I had a similar problem a few days ago - drove me crazy!!
The answer was to do 3 things
=Text(C2,"00000") first to get the zero leading the 4 digit zips
Then do an append of nothing to each cell - Like E2 = D2 & ""
Lastly do a copy and paste of values only over the original column.
Note - make sure column is formatted as text.

See attached for what I did.
This looks the most straightforward so far. Do you have a recommendation for an easy way to add names and do a re-sort. It would be done by someone who's even less proficient than I am! Thank you for any ideas.