Home

Serial number

%3CLINGO-SUB%20id%3D%22lingo-sub-1186897%22%20slang%3D%22en-US%22%3ESerial%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186897%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%3C%2FP%3E%3CP%3EI%20need%20a%202%20two%20Serial%20Column%26nbsp%3B%3C%2FP%3E%3CP%3Ecolumn%20A%20is%20Normal%20Serial%20for%20eg.%200000001%26nbsp%3B%20to%200100000%3C%2FP%3E%3CP%3Ecolumn%20B%20is%20000001%20this%20number%20change%20after%20100%20row%20to%20000002%20then%20after%20100%20row%20000003.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20are%20formula%20to%20change%20number%20after%20100%20Automatially..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eproper%20file%20are%20attached..%20but%20i%20can't%20creat%20a%20new%20file%20please%20describe%20me%20fully%20detailed%20what%20formula%20use%20in%20the%20file%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1186897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1187018%22%20slang%3D%22en-US%22%3ERe%3A%20Serial%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1187018%22%20slang%3D%22en-US%22%3ETry%20this%3A%20%3DTEXT(CEILING.MATH(ROW()-1%2C100)%2F100%2C%22000000%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1187214%22%20slang%3D%22en-US%22%3ERe%3A%20Serial%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1187214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F565065%22%20target%3D%22_blank%22%3E%40Kashif1165%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FabioO365GoD_0-1582299588955.png%22%20style%3D%22width%3A%20647px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172505i958BE16C3ECECD2C%2Fimage-dimensions%2F647x76%3Fv%3D1.0%22%20width%3D%22647%22%20height%3D%2276%22%20title%3D%22FabioO365GoD_0-1582299588955.png%22%20alt%3D%22FabioO365GoD_0-1582299588955.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FabioO365GoD_1-1582299618489.png%22%20style%3D%22width%3A%20647px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172506i1F48687B25CD33AF%2Fimage-dimensions%2F647x97%3Fv%3D1.0%22%20width%3D%22647%22%20height%3D%2297%22%20title%3D%22FabioO365GoD_1-1582299618489.png%22%20alt%3D%22FabioO365GoD_1-1582299618489.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20change%20the%20divisor%26nbsp%3Breload%20the%20current%20tab%2C%20press%20%3CSTRONG%3EShift%20%2B%20F9%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies
Highlighted
Try this: =TEXT(CEILING.MATH(ROW()-1,100)/100,"000000")
Highlighted

@Kashif1165 

FabioO365GoD_0-1582299588955.png

FabioO365GoD_1-1582299618489.png

 

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