View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default QUICK FORMAT WITH APOSTROPHE

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