excel表格中如何将16位,17位数的身份证转化成18位?答:假设数据是在A列 b2单元 格输入 =IF(LEN(A2)=15,REPLACE(A2,7,,19)&MID("10X98765432",MOD(SUMPRODUCT(MID(REPLACE(A2,7,,19),ROW($1:$17),1)*2^(18-ROW($1:$17))),11)+1,1),IF(LEN(A2)=16,REPLACE(A2,7,,19),IF(LEN(A2)=17,A2&MID("10X98765432",MOD(SUMPRODUCT(MID...