Zeor to the end of 4 digit number Solved/Closed

Question

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.

rizvisa1 · Answer

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)

billkirby · Answer

multiply the cell by 10

Zeor to the end of 4 digit number

2 responses

Similar discussions

Subscribe To Our Newsletter!