Zeor to the end of 4 digit number

Crafish - Feb 26, 2010 at 01:57 PM
 billkirby - May 9, 2010 at 03:41 PM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 26, 2010 at 02:10 PM
use this formula

Let say value is in A1
then in B1

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)
multiply the cell by 10