View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paperback Writer Paperback Writer is offline
external usenet poster
 
Posts: 23
Default Insert Leading Characters If String Is Only 7 Characters

I need to insert a leading zero. But, I only need it in the event that the
string is only 7 or fewer characters.

3032009 would become 03032009
12122008 would remain 12122008

Thank you!!!