Thread: Insert Leading Characters If String Is Only 7 Characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
  
Posts: 866
Default Insert Leading Characters If String Is Only 7 Characters
In B1, use the formula =text(a1,"0000000")


"Paperback Writer" wrote:

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!!!
Reply With QuoteReply With Quote