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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Leading Zeros 4
Adding a leading zero to a SSN 12
Inputting variable length data - outputting fixed character result 2
Leading Zero dropping off after export to Excel 3
convert format to value ? 2
Padding cell length with leading zeros 3
Leading Zeros 2
Leading Zero as value not appearance 2

Top