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!!!

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!!!

Insert Leading Characters If String Is Only 7 Characters
 

=TEXT(A2,"00000000") if you want it as text, or format the display as
00000000
--
David Biddulph

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!!!