Insert 0 Between Number

[muhammad susanto]

hi all...

how to solve this problem :

Book1
	A	B	C
1	DATA	FORMULA	AFTER FORMULA
2	B19	B19	B019
3	H6	H06	H006
4	H326	H0326	H326
5	A1	A01	A001
Sheet1

Cell Formulas
Range	Formula
B2	=IF(LEN(A2)=3,A2,REPLACE(A2,2,,0))
B3	=IF(LEN(A3)=3,A3,REPLACE(A3,2,,0))
B4	=IF(LEN(A4)=3,A4,REPLACE(A4,2,,0))
B5	=IF(LEN(A5)=3,A5,REPLACE(A5,2,,0))

any help, thanks in advance...

m.susanto

 

[Peter_SSs]

Try
=LEFT(A2,1)&TEXT(MID(A2,2,3),"000")

 

[muhammad susanto]

hi Peter...

once again, how about this :

6 ------006
16-----016
216----216

thanks..

 

[Peter_SSs]

hi Peter...

once again, how about this :

6 ------006
16-----016
216----216

thanks..

Either the formula
a) =TEXT(A2,"000")
or
b) Simply format the original cells with the Custom Format of 000