Zeor to the end of 4 digit number
Solved/Closed
Related:
- Zeor to the end of 4 digit number
- Unlock code 4 digit password lg tv ✓ - Forum - Smart TV
- Samsung mobile reset code 4 digit - Guide
- What is the 4 digit country code for usa? - Guide
- Master reset code for Samsung sgh-f480v ✓ - Forum - Mobile
- Unlock Code - Forum - Android
2 replies
rizvisa1
Feb 26, 2010 at 02:10 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 26, 2010 at 02:10 PM
use this formula
Let say value is in A1
then in B1
write
for post fixing 0
=LEFT(A1 & "00000", 5)
for prefixing 0
=RIGHT("00000" & A1, 5)
If you do not want formula, once its it done, copy the cell and paste special as values and then delete your A column so it will be back to as you original status (plus the extra 0)
Let say value is in A1
then in B1
write
for post fixing 0
=LEFT(A1 & "00000", 5)
for prefixing 0
=RIGHT("00000" & A1, 5)
If you do not want formula, once its it done, copy the cell and paste special as values and then delete your A column so it will be back to as you original status (plus the extra 0)