Thank you so much. It worked like a charm.
I've been trying off & on to find an answer to this for years.
You're the best.





On Tue, 22 Jul 2008 10:22:04 -0700, M Kan <tipsoftheweek at gmail dot
com wrote:

I've run into this too. Try running a VALUE(cell ref) command on the first
zip code and then copying the data down. You can then copy and paste as
values back into the original data column.