Excel Formula Reference

6 Position Number in cell A1 (e.g. 012345)

Place each digit in their own position.

0 in cell C1

1 in cell D1

2 in cell E1

3 in cell F1

4 in cell G1

5 in cell H1 

=================================================== 

=INT(A1/100000)

=INT((A1-(C1*10000))/1000)

=INT((A1-((C1*100000)+(D1*10000)))/1000)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)))/100)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)+(F1*100)))/10)

=INT((A1-((C1*100000)+(D1*10000)+(E1*1000)+(F1*100)+(G1*10)))

=========================================================