Zeor to the end of 4 digit number

Solved/Closed
Crafish - Feb 26, 2010 at 01:57 PM
 billkirby - May 9, 2010 at 03:41 PM
Hello,
Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell.
I get a excell file with the 4 digit number but my data base requires a 5 digit number with the 0 on the end, I can't import until I add the 0 to the number, it a lot of work, there must be an antimated way.

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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)
0
multiply the cell by 10
0