B2=IF(LEFT(RIGHT(A2,3))="-",REPT(0,RIGHT(A2,2)),"") C2=SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND("E",A2)-1),"-",),".",) D2=IF(LEFT(RIGHT(A2,3))="+",REPT(0 ...
確定! 回上一頁