=MID(D1,LEN(D1)-1,1)=LEFT(RIGHT(D1,2),1)以上2个办法截取皆可
=IF(left(RIGHT(D1,2),1)="0",D1,"")
适应mid函数if(mid(d1,2,1)="0",d1,"")
=IF(RIGHT(INT(D1/10),1)="0",D1,"")
