逢36進位 (12304)

(先)E2:J21=CHAR(MOD(INT($B2/36^(6-COLUMN(A1))),36)+48+(MOD(INT($B2/36^(6-COLUMN(A1))),36)>9)*7)

另解 E2:J21=MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",MOD(INT($B2/36^(6-COLUMN(A1))),36)+1,1)

C2=E2&F2&G2&H2&I2&J2



留言