Start row with zero and continue adding.

Hi Team

I need formula in Q10 ,i have attached workbook for refrence.

Choose cellformat: 00000000

hey Popipipo,

thanks for reply but there is one Problem in S10,when i CONCATENATE P10&Q10 figure showing less 1 digit.????

change the formula in S10:

Please Login or Register  to view this content.

Thank u very much solved.

@ visha_1984

For a number: =(P10&TEXT(Q10,"00000000"))+0 and format the cells as a number.