Insert Leading Characters If String Is Only 7 Characters

P

Paperback Writer

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

David Biddulph

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