Excellent! Aside from what I've posted, I have not found another easy way to
do this. I will be interested to see if anyone else has a different approach.

Jeff

"William" wrote:

Thanks, Jeff. Worked perfectly and saved me a lot of grief.
--
William


"William" wrote:

I have a column with several thousand rows in the 5-digit Special zipcode
format. I'd like to keep the 5-digit values the same (some begin with a
leading zero), but need to have the data in the text format that BEGINS WITH
AN APOSTRAPHE. Is there a way to convert the entire column quickly?
--
William