Need the zero to be return in front

[serge]

Hi,

I have this formula that separate a whole number into individual cell, this number have a total of 10 digits always but sometime the the number start with zero so my formula doesn't return those zero from the front number ( in green ) and I need it to be, keeping the same formula if possible, what need to be change for this to work ?

Excel Workbook
	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ
6	1021100000		1	0	2	1	1	0	0	0	0	0
7	201110000		0	2	0	1	1	1	0	0	0	0
8	32000000		0	0	3	2	0	0	0	0	0	0
9	2210000		0	0	0	2	2	1	0	0	0	0
Sheet

 

[serge]

Anyone has an idea ?

 

[Scott T]

Try

[COLOR=#000000][FONT=Arial]=IFERROR(0+MID[/FONT][/COLOR][COLOR=#000000][FONT=Arial](RIGHT[COLOR=#0000FF](REPT[COLOR=#FF0000](" ",10)[/COLOR]&$BF6,10)[/COLOR],COLUMNS[COLOR=#0000FF]($BH:BH)[/COLOR],1)[/FONT][/COLOR][COLOR=#000000][FONT=Arial],0)[/FONT][/COLOR]

 

[serge]

Thank you Scott, it works, I really appreciate it.
Serge.