Suresh Kusunuri
Board Regular
- Joined
- Dec 28, 2007
- Messages
- 138
- Office Version
- 2007
- Platform
- Windows
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
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