一大写一小写 (10852)


D6=IF(MOD(COLUMN(A1),2),TEXT(LEFT(RIGHT(REPT(0,19)&$W5/1%,INT((21-COLUMN(A1))/2))),"0;;V"),TEXT(LEFT(RIGHT(REPT(0,19)&$W5/1%,INT((21-COLUMN(A1))/2)))*1,"[DBNUM2]0;;V"))


留言