I am pulling SSN out of one of my systems and putting it in excel.
When it comes out of my AS/400 it does not have a leading zero if
needed. I need a have a formula that will add a zero to the begging
of a 8 character string if needed but if is in already 9 characters
long I need to leave it alone.

A1 has the SSN in text, which is how I need it. I need A2 to have the
SSN with the leading zero if not 9 characters long.