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

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