Formating a Cell

[Suresh Kusunuri]

Hi All,

I have codes like “29ABCDE1234X2YZ” or “2ABCDE1234X2YZ”. The code should be total 15 Digits/Letters.
In the second code it contains 14 Digits/Letters only.
Can anybody suggest me to prefix “0” before 2 by formatting the cell (without using formula or function).
Because I want to use a formula by using LEFT(___,2).
I used “000000000000000” in custom format. But it’s not worked.

Thanks in Advance
Suresh

 

[Peter_SSs]

You're welcome. (Not forgetting footoo's formula that also does what you asked. )

 

[Suresh Kusunuri]

You're welcome. (Not forgetting footoo's formula that also does what you asked. )

yes, Thank You.

 

[Suresh Kusunuri]

Maybe : =LEFT(REPT("0",15-LEN(A1)) & A1,2)

Thank you. Mr. Footoo. It's working.
Suresh