Serial number

[Kashif1165]

hello

I need a 2 two Serial Column 

column A is Normal Serial for eg. 0000001  to 0100000

column B is 000001 this number change after 100 row to 000002 then after 100 row 000003.

what are formula to change number after 100 Automatially..

proper file are attached.. but i can't creat a new file please describe me fully detailed what formula use in the file  

[#2]

Try this: =TEXT(CEILING.MATH(ROW()-1,100)/100,"000000")

[#3]

@Kashif1165 

if you change the divisor reload the current tab, press Shift + F9