Need to put leading 0s back

[i.beard]

I have a group of #s, some had leading 0s some did not. They should all be 11 digits however even though the column is formatted as text, it took the leading 0s off. I know there is a formula to put them back I just can't figure out what it is...
For instance if the length of a2 = 10 add "0" at the beginning of the #.

 

[pgc01]

Hi

Try:

=TEXT(A1,"00000000000")

 

[i.beard]

Thank you for your reply.

=IF(LEN(A2)=10,"0"&A2,IF(LEN(A2)=9,"00"&A2,IF(LEN(A2)=88,"000"&A2,"NA")))

Was what I was looking for I think.

 

[pgc01]

Looking at your formula it seems that you don't want numbers with less than 8 digits.

In that case you can also use:

=IF(LEN(A1)>=8,TEXT(A1,"00000000000"),"NA")

 

[mikerickson]

Perhaps
=RIGHT("00000000000"&A1,11)

 

[i.beard]

Those all seem to be good solutions. Thank you.