符號后面是個位時 添加0 (12951)

C2=CHOOSE(LEN(MID(B2,FIND("-",B2)+1,9))-2,SUBSTITUTE(B2,"-","-0"),SUBSTITUTE(B2,"-","-0",2-(RIGHT(B2,2)*1>0)),B2)

前面固定3數 C2=CHOOSE(LEN(B2)-6,SUBSTITUTE(B2,"-","-0"),SUBSTITUTE(B2,"-","-0",2-(MID(B2,6,1)="-")),B2)



留言