FILL SERIES

krish86 @vijay

Hii Krish,

   I have solve your problem, the method which i have followed:-

Fill a normal serie in A Column like as 1,1,2,2,3,3,4,4,5,5,6,6,7,7

then put this formula =REPT(0,13-LEN(A1)) in B1 Because series is start A1,

and again put this formula ="0476"&B1&A1 and Drug drop the formula and your series is done

04760000000000001
04760000000000001
04760000000000002
04760000000000002
04760000000000003
04760000000000003
04760000000000004
04760000000000004
04760000000000005
04760000000000005
04760000000000006
04760000000000006
04760000000000007
04760000000000007
04760000000000008
04760000000000008
04760000000000009
04760000000000009
04760000000000010
04760000000000010
04760000000000011
04760000000000011
04760000000000012
04760000000000012
04760000000000013
04760000000000013