Zeor to the end of 4 digit number
Solved/Closed
Related:
- Zeor to the end of 4 digit number
- Samsung mobile reset code 4 digit - Guide
- Gta 4 download - Download - Action and adventure
- Cartoon animator 4 download - Download - Illustration and animation
- Unreal engine 4 download - Download - Game development
- What is the 4 digit country code for usa? - Guide
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 26, 2010 at 02:10 PM
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)